Of course, make 6 backups before you do anything. I could also dump the SQLite data and reconfigure a different approach for making the new data available to my application, e.g. MQTT.
If sometime wants to get current data as it happens, MQTT is great. I use that to send temp/etc. to Home Assistant. HA then puts this is a database, but HA has no way to query weewx's database. And, if the net is down, there is no backfill. It sounds like you really want to do database queries over time, and if so that's not really a good match for MQTT. 1. install MariaDB on the WeeWx Pi 2. reconfigure WeeWx to use MariaDB using essentially the same steps as a fresh install (should I do a fresh WeeWxinstall?) 3. Pull data from SQLite and migrate it to MariaDB (best utility for doing this?) so I have all the almost 2 years of collected data available. You are not he first to want to do this, but it is, as I read the docs, much easier: See http://www.weewx.com/docs/utilities.htm#wee_database_utility and specifically --transfer.option. -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/rmisg6320ti.fsf%40s1.lexort.com.
signature.asc
Description: PGP signature
