Uploaded October 2019 | Updated September 2026, 3 weeks ago

---

In previous videos we looked at how we store IOT data in a SQL database using Node-Red .In this video tutorial you will learn how to create a web query form using dashboard nodes to query a sql database and display the data on a dashboard using the template node.
We use standard dashboard nodes and store the query in a node-red context variable using a function node. When we click submit function node builds the SQL query and passes it to the sql node in the topic field.
The sql node executes the query and the results are displayed using the template dashboard node in the form of a table.
The flow also contains a convert time function which converts Unix time into a familiar format to display.You may find useful in other projects


We look at building SQL queries and then executing them.
-------------------------------
Tutorial on site including flow
stevesnoderedguide.com/storing-iot-data-sql-database


Related videos
Node-red Storing IOT data In a SQL Database
youtu.be/d8eeNROMTv0
Node-Red Storing IOT data In a SQL Database-Part 2
youtu.be/fwF5xijNIWI

------------------------




If you find these videos useful then you might want to consider buying me a coffee
paypal.me/StepenCope