The IKEA TRADFRI motion sensor is a versatile and affordable device that integrates seamlessly into your smart home zigbee setup. I personaly use them in a cuple of places, in the postbox to notify me on new mail and in some rooms to switch on the light. However, its reliance on tow CR2023 coin cells can be a bit of a drawback. These small batteries, while compact, tend to have a relatively short lifespan, especially in devices that see frequent use. Further more in my use cases a small form factor is not needed, so I decied I’m tired of frequently replacing the coin cells. My solution is replacing the CR2023 cell with AA batteries.
Extending the Battery Life of Your IKEA Motion Sensor: Replacing CR2023 Cells with AA Batteries
- Posted on
- by admin
- - 4 minutes read
More ...
Unlocking Time: Harnessing the power of temporal tables in SQLite
- Posted on
- by admin
- - 5 minutes read
SQLite is a remarkable, versatile and widely adopted embedded relational database. SQLite’s lightweight nature, ease of integration and broad cross-platform support make it a go-to choice for developers seeking an efficient solution for storing data. Also, SQLite is very capable, but some features aren’t included out of the box. One of those not-included features is temporal tables. What that feature is, why it’s useful, and how to get it working with SQLite will be described in this post.
What are temporal tables?
Temporal tables, also known as temporal data tables, are a feature in database systems that allow you to keep track of states of data over time. These tables store historical versions of data, providing a way to query and analyze how data has evolved over different points in time. A mechanism to fly back in time, so to speak. Such a feature is especially useful when handling data that does not only consist of immutable facts, but also data that is mutable or somewhat mutable. There is more mutable data than one might think. Let’s look at an example, a table of employees:
Modern TLS Version for dovecot & postfix
- Posted on
- by admin
- - 1 minute read
(TLS 1.2 or newer)
You can use the following settings to ensure that Dovecot and Postfix use a modern TLS version:
For Dovecot:
- Open the file /etc/dovecot/conf.d/10-ssl.conf (Debian).
-
Uncomment the line starting with
ssl_min_protocoland set it tossl_min_protocol = TLSv1.2.
For Postfix:
- Open the file /etc/postfix/main.cf (Debian).
-
Add the following directive:
smtpd_tls_mandatory_protocols = !SSLv2,!SSLv3,!TLSv1,!TLSv1.1.
Finally, reload Postfix with systemctl reload postfix and restart Dovecot with systemctl restart dovecot.
Archiv
Categories
- Allgemein(75)
- Android(1)
- Daily Picture(57)
- FSyncMS(10)
- In 25 Tagen Durch Deutschland - Zug Um Zug(16)
- Interrail 2009(17)
- Nachdenklich(37)
- Out of My Head(23)
- Out of My Life(57)
- Pastes(24)
- Reisen(31)
- Softwarefund(2)
- Synchronsiation(21)
- Technik(96)
- Twitter(4)
- Uncategorized(73)
- Visit England(14)
- Zitate(17)