Is there a convenient way to add historical data to the database?
I used ioBroker in the past and stored sensor and entity data in a postgres db.
What would be the best approach to import this data to Home Assistant?
I’m not sure if there is a good way to add historical data to HA, and to be honest it doesn’t do a great job of handling it’s own historical data in my experience.
LTSS into InfluxDB and/or TimescaleDB with Grafana as a frontend seem to be fairly common for long-term historical data.
Thank you. You wouldn’t recommend it’s frontend for larger datasets either?
I’m already using Grafana but hoped for a seeming less integration in HA
This forum post hints at some of the complexities involved with handling long-term data natively in HA: https://community.home-assistant.io/t/long-term-statistics-what-is-the-retention-policy-and-how-can-it-be-changed/335050
Needless to say, HA is a great tool, and its short-term monitoring capabilities are decent, but it isn’t great at everything and I think that processing datasets >10 days is just not really within it’s capabilities at this time.