If you haven’t played with Pulumi (for configuring cloud services) and Ansible (for local services, shell commands, apt installs etc) you may enjoy them as a way to capture / re-apply configuration.

Hmm, it’s been a while, maybe I’m misremembering. There were definitely some categories of Plex content not from my library that kept reappearing on the home page of my server, despite trying to get rid of them a few times. Maybe they weren’t actually paid, I just assumed they’d only be pushing something if it was going to bring them more revenue.

The other thing that made me want to jump ship extremely fast was when they started sharing your recently watched items with other users, without asking.

Even with Plex pass they were really pushing their paid content. Much happier with Jellyfin, and it was very easy to switch.

I have ESP8266 WiFi modules running Tasmota firmware for a few parts of this. Some report temperature (and humidity just for fun), I like DS18B20 sensors better than SHT30s which seem to have a bit more self heating. Then I also have Mitsubishi mini split heat pumps for which there’s a Tasmota control library. MQTT for communication + HomeAssistant for UI + AppDaemon for automation scripts in Python.

Examples of the UI in HA:

Yeah, every time I find some weird annoying behavior or some missing feature in MySQL, PostgreSQL is doing it right.

That said, also ask yourself if you really need a relational database, or whether an object store or append-only / timeseries db would fit better.