Node-Red -Store and Retrieve JSON Data from a SQLite Database

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
Tutorial on site
Flow Download
Related videos
Reading IOT Data From a SQL Database with Node-Red
---------
Node-Red Storing IOT data In a SQL Database-Part 2
------------------------

Node-red Storing IOT data In a SQL Database

[alejandrolorenzut]

Thank you very much for your work!
Cordial greetings from the city of La Plata, Argentina.

[tim]

Thanks as always Steve. You jump right in and get busy!! Love the method.

[higiniofuentes]

If we have the data in XML there are functions like xml_*?
And with CSV format?

[higiniofuentes]

The functions json_* are related only to SQLite?