I would like to setup a system on which i can store my energy data in a database (thinking about mysql, influxdb, prometheus, etc…) and on which i can show the data in graphs (eg with grafana). Preferably i would like to put the database on the google cloud…if possible
For the above i would like to have your advise on what to choose for this?
Thanks in advance !
Interesting topic:
1 Like
Here is an example for writing values via flow into a database. If mySQL makes sende depends on the way you want to visualize the data.
As small version you could use MS Excel with a mySQL ODBC addon. Then you can create Pivot tables and charts.
Thanks Peter and Ronny for your help !
1 Like
I have set up a dedicated InfluxDB + Grafana server (Debian) which is also accessible from the internet. InfluxDB runs with 2 databases, first DB is old data from my HomeAssistant system that I don’t use anymore, but of which I still have the data. Second DB is my Homey Pro data. Both combined in one graph each to have data continuity.
So in my case, InfluxDB app (Homey) => Grafana.
Hereunder a screenshot, it does everything that Insights is missing and it’s rather simple to setup.
how do you get the old history, thats in homey transfered to influxdb?
like last month last year etc
I would argue that Homey doesn’t store any worthwhile historic data, all you have is averages with ever decreasing resolution.
Indeed. But it’s not ever decreasing 
After a month and onwards, it’s averaged to one mean value a day
Besides the discussion about what to call it, I’m mainly looking for a way to export the data we’re talking about to Influx.
Does this have to be done manually per device, or is it possible to push the "database with stored data " in Homey to Influx using a flow card?
i dont mind that its increased. its just for archiving. i know its there and just want to save it to a place were i kan keep it save.
You can achieve this with the Archive Insights app linked earlier by @Peter_Kawa.
You can use a flow to e.g. export all insights every day at the end of the day for all devices in one go and store them on an FTP-server/NAS. The app creates a zip-file per Homey app. The zip-file includes all insights for all devices created by that app. Both in csv- and json-formats.
that app i tried. but i coulndt just get a instant graph out of that data in a click.
thats what ik like from influx/grafana 1 click and i have my visualistation.
and the csv i create from that app isnt annoted so i cant import into influx.
its all so complicated for a noob like me hahaha
but the question stays open. is it possible to push/pull the archived data what is on my homey to influx. with for example the influx flow cards?
This is not possible with “1 click”.
If ‘Energy data’ means gas and electricity usage…
For exactly this, I still have Domoticz running on my NAS. It stores all data from my P1 meter and has some simple graphics built in.
If you are interested in only some devie insights, you could use the MySQL app. You can push every capability change to a database. It’s not Influx, but just to store it’s a possible way.
You could let Homey save data in a Googlesheet and use the googlesheet plugin for grafana. (I have no experience with this myself)
