SQLx 0.9 will have a sqlx.toml format that can specify DB connections. It was merged a while ago but isn't released yet. It was nice for updating calibre-metadata-api to have multiple sqlite DBs (PG example), one for Calibre and one for Calibre-Web. Without this support the builds with 2 databases would fail for any query_as! macros connecting to the incorrect DB.
Reading the Home Assistant release notes I saw that Switchbot now has time offset function for the Meter Pro devices. I was looking for a way to set the time on the devices directly with Home Assistant ... which thanks to actually reading the docs, already exists!
The Meter Pro devices seem to lose a minute every week or so unless manually synchronized.
Since leaving Cointracker I was hoping not to really deal with them again. I'm looking into some discrepancies with a crypto exchange that uses Cointracker for tax documents. It looks like some timezones were lost in transactions and are then getting reported for the wrong year! Some final hours 2024 transactions are 2024 my-local-time but 2025 UTC.