In this video I will take you step by step through the process of storing IOT data in a SQL database.
In the video we will use a SQLite database because it is easier to setup and this is especially important if you copy the flow and use it locally.
However the process is the same for other SQL databases
We look in detail on how you create the database commands and pass them into the SQLite connector node and how you can detect errors.
There is an error in the video regarding errors as you need the catch node to detect errors as the sqlite node doesn’t output them on the output node.
This is a 2 part video series in the second vidoe we will look at storing JSON data, including how to extract elements to use as coulmn names.
Tutorial on site
http://www.steves-internet-guide.com/storing-iot-data-sql-database
————————————-
Flow Download
http://www.steves-internet-guide.com/downloads
————-
Related videos
Node-Red- Moving Messages between Flows Without Wires
https://youtu.be/Yux1Ppvf2gg
Related Post:
- Storing IoT device data on blockchain with IBM Watson IoT Platform and IBM Blockchain Platform
- Amazon Web Services (AWS) IoT MQTT Node-RED Raspberry Pi & PLC
- Parrot Anafi / Lüfterloser Mini-PC PrimeMini 4 / IoT-Frickeln mit Node-Red [c’t uplink 23.0]
- Doorbell WiFi Upgrade [DIY, IoT, Node-RED, WLED]
- IoT and Data API-Sending Sensor Data to FileMaker Server from a Raspberry Pi [ITG 03]
- Azure Data Explorer for IoT Data Analytics
- Sell Your Data! – Earn CryptoCurrency Selling Data! – Marketplace for the IoT! – DataBroker DAO
- How to configure the DCN (Data Communication Network) in Ericsson Traffic Node via CLI?
- Ripple XRP: Is Ripple XRP an Illegal Security and Best Secure Wallet for Storing XRP
- Buying, Selling and SAFELY STORING Bitcoin?! – Mining Adventure Part 4