SQLite queries used in tutorial

sqlite_commands.md

• Start REPL console. Use .quit anytime to exit.

$ sqlite3 test_db.db

• List Tables

.tables

• Create a Table

Check out supported types here

> CREATE TABLE sensors(id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255), value REAL, unit VARCHAR(100), timestamp DATETIME);

• READ from a table

> SELECT * FROM sensors

• INSERT data to a table

> INSERT INTO sensors (id, name, value, unit, timestamp) VALUES (null, 'SENSOR_1', 23.4, 'Volt',datetime("now"));