Email or username:

Password:

Forgot your password?
Fabio's posts Post Back to profile
Top-level
stfn :raspberrypi: :python:

@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.

30 Jul 2023 at 17:22 | Wall-to-wall | Open on fosstodon.org
3 comments
John Socks replied to stfn :raspberrypi: :python:

@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 ;-)

30 Jul 2023 at 17:33 | Open on socks.masto.host
Fabio Manganiello replied to John

@John @stfn @nf3xn @rrwo @szescstopni @Threadbane we often forget that there's actually a very lightweight way of running SQL that doesn't require any server, it can also fit into memory, and even into a WASM frontend - SQLite :)

It may not come with all the bells and whistles of a full-blown RDBMS (no stored procedures and triggers AFAIK), but it definitely solves the use cases of (I'd say) 90-95% of the applications out there.

I've actually got the db of my Matrix server (~20GB) fully running on SQLite, and I've been impressed by its versatility and performance.

@John @stfn @nf3xn @rrwo @szescstopni @Threadbane we often forget that there's actually a very lightweight way of running SQL that doesn't require any server, it can also fit into memory, and even into a WASM frontend - SQLite :)

It may not come with all the bells and whistles of a full-blown RDBMS (no stored procedures and triggers AFAIK), but it definitely solves the use cases of (I'd say) 90-95% of the applications out there.

30 Jul 2023 at 17:38 | Open on social.platypush.tech
Go Up