Uploaded May 2022 | Updated November 2026, 3 hours ago
In this video tutorial we look at how to store JSON data in a SQLite database and also how to query the database based on the JSON keys.
Storing data directly in JSON format has the advantage that it makes adding data easier and also changing the data easier as no fields need to be created or deleted.
Buy me a Coffee
buymeacoffee.com/steveH5u
Tutorial on site
stevesnoderedguide.com/storing-retrieving-json-data-sqlite
Flow Download
Related videos
Reading IOT Data From a SQL Database with Node-Red
youtu.be/pQvbvuo11Yk
---------
Node-Red Storing IOT data In a SQL Database-Part 2
youtu.be/fwF5xijNIWI
------------------------
Node-red Storing IOT data In a SQL Database
youtu.be/d8eeNROMTv0
In this video tutorial we look at how to store JSON data in a SQLite database and also how to query the database based on the JSON keys.
Storing data directly in JSON format has the advantage that it makes adding data easier and also changing the data easier as no fields need to be created or deleted.
Buy me a Coffee
buymeacoffee.com/steveH5u
Tutorial on site
stevesnoderedguide.com/storing-retrieving-json-data-sqlite
Flow Download
Related videos
Reading IOT Data From a SQL Database with Node-Red
youtu.be/pQvbvuo11Yk
---------
Node-Red Storing IOT data In a SQL Database-Part 2
youtu.be/fwF5xijNIWI
------------------------
Node-red Storing IOT data In a SQL Database
youtu.be/d8eeNROMTv0










