Home Assistant is open source home automation that puts local control and privacy first. Powered by a worldwide community of tinkerers and DIY enthusiasts. Perfect to run on a Raspberry Pi or a local server. Available for free at home-assistant.io
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.