Category Archives: Technik

Technik

Unlocking Time: Harnessing the power of temporal tables in SQLite

Posted on 19 February 2024 by admin

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

Posted on 4 March 2023 by admin

(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

Posted on 6 January 2023 by admin

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

Posted on 31 December 2022 by admin

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

Posted on 12 October 2022 by admin

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