Best way of storing historical data

Posted on
Wed Dec 07, 2016 1:47 am
trevorsmith offline
Posts: 86
Joined: Oct 08, 2016

Best way of storing historical data

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?

Posted on
Wed Dec 07, 2016 2:44 am
CrazyFin offline
Posts: 381
Joined: Jan 08, 2015
Location: Stockholm, SWEDEN

Re: Best way of storing historical data

@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

Posted on
Wed Dec 07, 2016 3:02 am
trevorsmith offline
Posts: 86
Joined: Oct 08, 2016

Re: Best way of storing historical data

Thank you very much.

Posted on
Wed Dec 07, 2016 8:29 am
DaveL17 offline
User avatar
Posts: 6742
Joined: Aug 20, 2013
Location: Chicago, IL, USA

Re: Best way of storing historical data

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

I came here to drink milk and kick ass....and I've just finished my milk.

[My Plugins] - [My Forums]

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest