In this video we look at how you store raw JSON data in a SQL database and how to extract keys from the incoming data for creating database columns that can be used for searching the data. Part 1 Node-red Storing IOT data In a SQL Database https://youtu.be/d8eeNROMTv0 Tutorial on site http://www.steves-internet-guide.com/storing-iot-data-sql-database Part 3 Reading Data from a SQL Database- https://youtu.be/pQvbvuo11Yk ------------------------------------- Flow Download http://www.steves-internet-guide.com/download/storing-iot-data-in-a-sql-database-video-part-2/ ------------- Related videos Node-Red- Moving Messages between Flows Without Wires https://youtu.be/Yux1Ppvf2gg Have a question Use the comments or if you want help then use http://www.steves-internet-guide.com/ask-steve/ If you find these videos useful then you might want to consider buying me a coffee https://www.paypal.me/StepenCope
In this video we look at how you store raw JSON data in a SQL database and how to extract keys from the incoming data for creating database columns that can be used for searching the data. Part 1 Node-red Storing IOT data In a SQL Database https://youtu.be/d8eeNROMTv0 Tutorial on site http://www.steves-internet-guide.com/storing-iot-data-sql-database Part 3 Reading Data from a SQL Database- https://youtu.be/pQvbvuo11Yk ------------------------------------- Flow Download http://www.steves-internet-guide.com/download/storing-iot-data-in-a-sql-database-video-part-2/ ------------- Related videos Node-Red- Moving Messages between Flows Without Wires https://youtu.be/Yux1Ppvf2gg Have a question Use the comments or if you want help then use http://www.steves-internet-guide.com/ask-steve/ If you find these videos useful then you might want to consider buying me a coffee https://www.paypal.me/StepenCope