I recently stood up a weather station and got the data flowing into HA. I’d like to do two things:
- Store the data long-term (years) so that I can reference it and possibly use it for future projects
- Build a weather dashboard and use data from the last ~30 days
While I’m tech savvy, I’m inexperienced with databases, so pretty much all of my questions are database ones.
I saw that InfluxDB is natively supported by HA and that seems like a good route to go. So…
- When setting up something like InfluxDB, do I have to configure the DB schema for the data being ingested? ie columns(temp, wind speed, wind direction, humidity, etc, etc)?
- How do I then use that data in things like graph-cards?
- If I have a DB containing ~2 years worth of data, will queries become slow, leading to issues with a dashboard? If so, I have the resources to host a DB elsewhere on my network while keeping a DB of ~30 days on HA, but not sure how to go about (1) piping out the data and (2) limiting the HA DB to X days of data.
TYIA