|
Top-level
 @nf3xn @blacklight @rrwo @szescstopni @Threadbane Ha! I remember one of the last times I used a SQL database for a trivial purpose .. garage temperature recording. I guess it cracked me up at that point how ridiculous it was to have a full unix(ish) stack and SQL to run a thermometer. As an added bonus this pi zero and the one in the kitchen communicated, doing data replication for fault tolerance. It's still funny to me. 6 comments
@stfn @nf3xn @blacklight @rrwo @szescstopni @Threadbane That sounds cool and much more modern. My boards answered my questions, which were basically about how the temperature cycle looked in my house with no heat or cooling (not present anyway) running. Before running the test I had not really internalized that the coldest part of the night is not midnight ;-)  @blacklight @John @stfn @nf3xn @rrwo @szescstopni @Threadbane sqlite has triggers. @John this is a very interesting project: do you have some links or details about hardware and software that you have used to achieve it? @seblm I think my method was a little idiosyncratic. If I remember correctly I used a DHT11 temperature sensor, and wrote c code to take a reading and insert it in the database. I just set that c code up as a cron job. I used shell scripts and cron jobs to do my data replication, database dumps and rsyncs if I remember correctly. There are lots of ways to skin the cat, and if you search for raspberry pi DHT11 (or DHT22) there will be lots of examples. |
Gregory's Server
@John @nf3xn @blacklight @rrwo @szescstopni @Threadbane ah yes, for my first temperature measurement I also used a Zero W with a Postgres db and a pythons script writing to it every minute. Now I use an RPi Pico sending data by MQTT to a server which ingests those messages to InfluxDb, which is read by Grafana.