Working with time series data in Node Red with SQLite

This video is going to be a first in a series on how to collect, display and aggregate time series data in Node Red. In this video I am using SQLite to store data, phpLiteAdmin for the basic database administrative activities. I discuss a few topics in this video:

1. How to store multiple data points in the table: generate multiple INSERT INTO
2. Back up dashboard graph state to a file and restore on startup.
3. Example on how to aggregate data stored in database: get max, min and last values daily and store aggregated values separately.
4. Generate graphs from values stored in the database using multiple data points in a single graph.

Flows shown in the video are available here: http://flows.nodered.org/flow/36f2de38ed4bb62cf3a5e8fdc76d779e

Create SQL commands: CREATE TABLE 'sensor_aggr' ('epoch' INTEGER NOT NULL, 'device' TEXT NOT NULL, 'sensor' TEXT NOT NULL, 'value' REAL, PRIMARY KEY ('epoch', 'device', 'sensor')) CREATE TABLE 'sensor_data' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'device' TEXT, 'sensor' TEXT,'value' REAL,'epoch' INTEGER, 'timestamp' INTEGER DEFAULT CURRENT_TIMESTAMP) ... https://www.youtube.com/watch?v=ccKspiI8FRw