tspi.at

LoRA WAN stuff often not seen

18 Aug 2020 - tsp

Reading time 13 mins

A short summary of LoRA WAN stuff that's often not seen by device and application manufacturers and developers. This blog post tries to give a short overview of network behavior and internals.

Recovering MySQL or MariaDB database via dump and restore

14 Aug 2020 - tsp

Reading time 8 mins

This blog post summarizes the steps for disaster recovery on MariaDB or MySQL in case the database system doesn't start up any more or contains damaged table definitions which might even prevent one from dropping tablespaces or databases.

A simple home-built epoxy counter-top

09 Aug 2020 - tsp

Reading time 12 mins

Short blog post about the casting of a simple epoxy countertop with embedded sink.

How stuff works - Line power distribution and protective measures in Europe (consumer side)

03 Aug 2020 - tsp

Reading time 20 mins

Since it seems to be a huge mystery to many people this blog post tries to summarize some of the parts relevant to the consumer side of power grid systems.

Automatic plant watering and illumination (smallest version)

26 Jul 2020 - tsp

Reading time 15 mins

In this blog article I'm describing a small automated plant watering solution that's used indoor to grow basil, capsicum and chili pepper indoor.

Z, ABCD, S and T parameters in two port networks

12 Jul 2020 - tsp

Reading time 10 mins

A short summary about the different meaning and interpretation of impedance, ABCD, scattering and transfer parameters in simple (linear) two port networks.

Repairing corrupted RabbitMQ instance (VHost / experienced error, not a dets file)

11 Jul 2020 - tsp

Reading time 2 mins

Mini post about an unusual error when using RabbitMQ - or mnesia in general. This is something that shouldn't happen and was also not expected to happen.

Runtime swapable and upgrade-able modules in ANSI C

09 Jul 2020 - tsp

Reading time 16 mins

This article describes an trick that I'm using in some of my applications to allow one to exchange modules or plugins inside an application at application runtime as well as keeping old versions active as long as they're required.

Capacitance measurement with AVR (simple, fast)

09 Jul 2020 - tsp

Reading time 6 mins

Mini article about the measurement of capacitance with AVRs with a minimum of external components (in it's most extreme form none external components exploiting the gate capacitance of the micro-controllers input)

Using Aspell to perform spellchecking (manually and inside the build pipeline)

05 Jul 2020 - tsp

Reading time 3 mins

Mini article about the usage of the Aspell spell checker on FreeBSD on the command line and inside the automated build pipeline for static webpages


Data protection policy

Dipl.-Ing. Thomas Spielauer, Wien (webcomplains389t48957@tspi.at)

This webpage is also available via TOR at http://rh6v563nt2dnxd5h2vhhqkudmyvjaevgiv77c62xflas52d5omtkxuid.onion/

Valid HTML 4.01 Strict Powered by FreeBSD IPv6 support