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/storing-retrieving-json-data-sqlite Flow Download Related videos Reading IOT Data From a SQL Database with Node-Red https://youtu.be/pQvbvuo11Yk --------- Node-Red Storing IOT data In a SQL Database-Part 2 https://youtu.be/fwF5xijNIWI ------------------------ Node-red Storing IOT data In a SQL Database https://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 https://www.buymeacoffee.com/steveH5u Tutorial on site https://stevesnoderedguide.com/storing-retrieving-json-data-sqlite Flow Download Related videos Reading IOT Data From a SQL Database with Node-Red https://youtu.be/pQvbvuo11Yk --------- Node-Red Storing IOT data In a SQL Database-Part 2 https://youtu.be/fwF5xijNIWI ------------------------ Node-red Storing IOT data In a SQL Database https://youtu.be/d8eeNROMTv0