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 t…

[image] Archive Insights Make backups of all insights [image] InfluxDb Metrics exporter for InfluxDb [image] Google Sheets Append to Google Sheets from a Flow. Interesting topic…

[image] MySQL Verwende deine MySQL-Datenbank in Homey

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. [image] [APP][PRO] MySQL-Client App…

Thanks Peter and Ronny for your help !

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 on…

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 :wink: After a month and onwards, it’s averaged to one mean value a day [1000044992]

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 increase…

[image] Astrapowerrr: 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-s…

Storing energy data

Energy

Peter_Kawa January 13, 2025, 10:00pm 2

Interesting topic:

Topic		Replies	Views
Influx + Grafana Questions & Help	12	2808	March 2, 2025
Visualize and store data from Homey and other sources Questions & Help	4	2213	April 12, 2022
Insights with persistant stats Questions & Help	5	703	September 10, 2022
[APP][Pro] InfluxDb Apps app	180	11709	April 30, 2026
[FeatureRequest] WebApp - Inzichten Grafieken Bewaren Ideeën & Suggesties app , featurerequest	6	1185	July 8, 2022

Storing energy data

Related topics