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
https://www.buymeacoffee.com/steveH5u
Tutorial on site
https://stevesnoderedguide.com/storin...
Flow Download
Related videos
Reading IOT Data From a SQL Database with Node-Red
• Reading IOT Data From a SQL Database ...
---------
Node-Red Storing IOT data In a SQL Database-Part 2
• Node-Red Storing IOT data In a SQL Da...
------------------------
Node-red Storing IOT data In a SQL Database
• Node-Red Storing IOT data In a SQL Da...