Storing data to SQLite from Node-RED

The video is about integration of SQlite database with nodered. This will let you store lighweight data without spinning up any other database server like MySQL or MongoDB etc.

INDEX:-

0:00 - Intro

00:10 - Create DB file and table using SQLite CLI

01:22 - Add support for SQLite to Node-RED

01:46 - Configure SQLite DB in Node-RED

02:30 - READ from DB using Fixed statement

03:30 - Write to DB using Via msg.topic

07:08 - Wite to DB using Prepared statement

09:10 - Write to DB as Batch

🔗Relevant Links:- ----------------------------------------------------------------------------------------

🔗Used Node-RED Library: http://bit.ly/3JuvlIk

🔗Node-RED Flow: http://bit.ly/40cruVR

📽️ Other Node-RED Videos: http://bit.ly/3T4rVPl

📽️Install SQLite on Raspberry Pi: http://bit.ly/3Tk1aXv