Long term statistical data becomes more and more valuable over time. It should be held in a separate database. It should be possible to move it to another db engine with less chance of corruption than sqlite. It should be easy to backup without all the other recorder data (that is purged after 10 days anyway).
How is backing up two databases easier than one?
I didn’t want to backup the non-long term data at all. It consumes valuable cloud backup space and is purged after 10 days anyway.
1 Like
The influxdb integration is probably what you want
I don’t think so. This integration moves the whole state db. I am talking about long term statistics only.
Right, so disable recorder and use influxdb to only get the states table in influxdb.
1 Like
Well, no, it creates an entirely separate DB for your own use. HA doesn’t use the data in influxdb at all.