i am getting a beelink eqi12 to run HA and few VMs.
I got sensors (CO2, humidity, temp, shelly …) and a solar edge PV system that i want to store the data from.
How is a good way to do this?
Installed influxdb and grafana through add-ons page. Saved the data in influxdb and did the visualisation in grafana. So far so good but using grafana in a dashboard as an iframe resulted in problems caused by protection features.
Some suggested to install influx db and grafana in an own VM to get rid of those “ingress” problems. Is it easy to connect influxdb/grafana in HA when its on a seperate VM?
How would you do it? Thought saving and displaying data is a standard-case.
There is no good way to share Grafana graphs in Home Assistant. Search the forum. There are many posts on this and they all have one problem or another.
e.g. if using ingress you have to visit the add-on web page to set up the ingress session before you see them in your dashboard. You have to do this every time you visit the HA dashboard.
Alternatively there are methods to pull images from Grafana but these do not update in real time.
There are advanced 3rd party graphing solutions (e.g. ApexCharts or Plotly) for better graphing in HA using the data in the recorder database if you are not happy with the core graphing features.
Thanks for the fast reply, awesome!
Looking at ApexCharty, Plotly and Mini Graph Card the visualisation options would be enough for me. Is there any option to use a database as the datasource or is there a common way to store some data long time in the recorder?
If your sensors have a state_class then they store long term statistics. 5 minute and hourly average max, min, total, change, etc for your recorder keep days setting (10 days by default). After that the 5 minute data (and raw state data) is deleted but the hourly stats are kept forever.
ApexCharts can use statistics or state data. Not sure about Plotly, I’ve not used it.
