

There are smart valves. You can just unscrew/unclip the existing dumb ones and replace them with smart ones. They usually even report the temperature (well, near the radiator - so you might want to get extra temp sensors for the other end of the room).
Ohh, SQLite isn’t “one” db. SQLite is file-based. I.e. a database in e.g. PostgreSQL (containing several tables, views, indexes, etc.) would translate to one SQLite file (e.g.
mydatabase.db3
ormyappdata.sqlite
). And each app has its own file/database. If the file corrupts, then it’s only affecting that specific app. (However, SQLite is pretty robust.) And since these are just files, you can backup them together with the application. No need to export data or shutdown the database first.