>From what I understand weewx uses sqlite because of the default, and with sqlite the only possibility is to dump the whole database every time (https://github.com/glennmckechnie/weewx-sqlbackup/wiki/SQLBackup-README), which is obviously time consuming.
With Pandas you can get around that by doing queries and requesting only the data that you need to transfer every time, and the data gets saved into the memory allocated by Python so the db is left untouched. Of course one does not necessarily have to use Pandas, it's just one of the framework that I'm familiar with. Plus, it seems that none of the extensions in the wiki allows for saving data directly into a DB but only for making a physical copy of the DB (again, from my understanding). On Thursday, July 28, 2022 at 4:23:04 PM UTC+2 [email protected] wrote: > Can you get there with doing mysql replication at the database level ? -- You received this message because you are subscribed to the Google Groups "weewx-development" 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-development/391c83da-fb02-447e-bcee-fed1b42bbbccn%40googlegroups.com.
