Storing Data in SQLite Using Node-RED -Beginners Workbook

Workbook Download

The workbook is here and includes a sample flow for the exercise. Please use a valid email address to receive any updates.

Answers to questions

Section 3 Answers

1.True
2.A
3.False
4.D
5.False
6.True
7.True
8..True

Exercise

Template

TIME INTEGER PRIMARY KEY,
DATA TEXT NOT NULL

query
select * from results where json_extract(data,’$.temperature’) >25 limit 4