Page 1 of 1

Best way of storing historical data

PostPosted: 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

PostPosted: 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 plugin

First set your temp device to report temp every 10th minute.

And then for plotting charts in different ways I would suggest either
IndigoPlotD
or
Matplotlib Plugin for Indigo 7

You 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

PostPosted: Wed Dec 07, 2016 3:02 am
by trevorsmith
Thank you very much.

Re: Best way of storing historical data

PostPosted: 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).