Working with time series data in Node Red with SQLite

Video Description

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)