Best way of storing historical data
Posted:
Wed Dec 07, 2016 1:47 am
by trevorsmith
For fun I wish o store the temperature every say, 10 minutes, and then after a few hours use that data for something (just printing it to the log for now).
What's the best way of storing an increasing list of data for use at a later date?
Re: Best way of storing historical data
Posted:
Wed Dec 07, 2016 2:44 am
by CrazyFin
@trevorsmith:
Indigo stores all events automatically if you have enabled the SQL-logger plugin.
Read more at
Indigo SQL logger pluginFirst set your temp device to report temp every 10th minute.
And then for plotting charts in different ways I would suggest either
IndigoPlotDor
Matplotlib Plugin for Indigo 7You can also use the
print SQL data in log file plugin to check what is stored in the Indigo SQL database
Re: Best way of storing historical data
Posted:
Wed Dec 07, 2016 8:29 am
by DaveL17
You can also use the CSV Engine included with the Matplotlib Plugin. It doesn't presently have a setting for every 10 minutes, but does do every 15 minutes. You can specify in the plugin how many observations to retain (default is 300 which is about 3 days at 15 minute increments).