Category Archives: Technik

Technik

Unlocking Time: Harnessing the power of temporal tables in SQLite

SQLite is a remarkable, versatile and widely adopted embedded relational database. Extending it to store temporal tables makes it even more useful. This post will tell you what temporale tables are, why they are helpful, and how to get them working with SQLite. Continue reading

Posted in Technik | Tagged | Leave a comment

Modern TLS Version for dovecot & postfix

(TLS 1.2 or newer) You can use the following settings to ensure that Dovecot and Postfix use a modern TLS version: For Dovecot: For Postfix: Finally, reload Postfix with systemctl reload postfix and restart Dovecot with systemctl restart dovecot.

Posted in Technik | Tagged , , , , , | Leave a comment

Setting up timesync via NTP on debian & raspberry pi

I use systemd-timesyncd to keep the system time up to date on my raspi / debian system.To do so i did the following steps: 1. Check the state of timedatectlTherefore type the comand timedatectl to the shell.The output should look … Continue reading

Posted in Technik | Tagged , | Leave a comment

Erase ESP – quickly reset the wifi chip

TLDR: Install esptool.py pip3 install esptool Erase flash of the esp esptool.py — erase_flash One of my smart ESP devices wasn’t responding after a power down. I debugged the problem by connecting it to a serial interface. On the comandline … Continue reading

Posted in Technik | Tagged , , , , , , | Leave a comment

reset your philips hue lightstrip without a dimmer switch – using deconz / conbee

To reset your philips hue lightstrip philip recomends using their dimmer switch. If you don’t have it or just are to lazy to use it you might also reset / repair the strip using deconz. To do so you need … Continue reading

Posted in Technik | Tagged , , , , | Leave a comment