Domoticz

I've written a windows application to scan tables in a SQLite backup db and import any new records into a MYSQL db.
This would be useful for anyone who wants to keep records for longer than the Domoticz 7 days limit.
The application can be run in either manual or unattended autorun mode and keeps a basic log of updates in the MYSQL db.

So far I've only run/tested the application on a MYSQL server running on my local network but I suspect that there would be no problems saving to a Maria DB on a NAS as long as the Maria db was configured not "Non-Localhost" access.

I've not compiled any documentation yet and I was wondering if anyone else would be intereted in the application.


SB

You can also use docker compose and install a container with InfluxDB and Grafana

@sjb66: Interesting!
Could this help with my issue?:
https://www.domoticz.com/forum/viewtopi ... ce#p312489

Is there a possibility to copy data from 1 table to an other table?
Can I restore the output as database file into Domoticz?

I'm pretty sure you can already do this with 'SQLite Personal Edition'. Open the database, right click on the database and choose 'Attach database'