I have 3 energy meters (Shelly 3EM) showing graphs in the dashboard of the latest 24 hours data. The data is received by MQTT topics
Now I want to store, search and preset the data in various graphs and histograms over longer time periods than only latest 24 hour. Example is to present a power consumption histogram over a selected period of months or year, or present the highest current for phase 1 for a specific period etc.
My question
What is the most preferred solution to store and extract data from? Tips of nodes to use is also welcome.
- Save to one file and continuously append data
- Save to multiple files, one per month
- Save data to database e.g. SQL, SQLite