Integrate #SQLite #database with #nodered | #beginners

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.

Chapters:-

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

🛳️Social Media Links:-
—————————————————————————————-

🎆 Twitter: https://bit.ly/3ZCbKer
🧑‍💻 GIT: https://bit.ly/3ZucstS
🎆 Facebook: https://bit.ly/3ZyMndf
🖼️ Instagram: https://bit.ly/3YedVng
📹 YouTube: https://bit.ly/3KR0PJG

Hey there 👋,

You can buy your products from Amazon by using the following link. For each product you buy, we will get some tips out of it.
And for this you don’t need to pay 💵 anything extra and offers will remain the same. This will help us to make videos like
this and maintain the channel.

Thanks 💕
Team WG

🔗Amazon: http://amzn.to/2wd4isr

—————————————————————————————-

#wglabz #iot #smarthome #homeautomation #weargenius