Import historical data to Home Assistant (discuss.tchncs.de)

submitted 1 year ago* (last edited 1 year ago) by ottk3@discuss.tchncs.de to c/homeassistant@lemmy.world

6 comments fedilink hide all child comments

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?

you are viewing a single comment's thread
view the rest of the comments

[-] mlaga97@lemmy.mlaga97.space 0 points 1 year ago

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.

[-] ottk3@discuss.tchncs.de 0 points 1 year ago

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

[-] mlaga97@lemmy.mlaga97.space 1 points 1 year ago

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.

this post was submitted on 24 Jun 2023

2 points (100.0% liked)

homeassistant

12007 readers

130 users here now

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

founded 1 year ago

MODERATORS

GreatAlbatross@feddit.uk