Advanced Node-RED & MySQL tips and techniques
In this video Opto 22's Terry Orchard takes a deep dive into the MySQL database nodes to insert data into and select data from a MariaDB server. Terry shows you how two different methods are used to insert: first using locally saved context variables within Node-RED, and then building up similar data in a single message object. Finally we select the data back into the flow and display it in a Node-RED dashboard table that is running on a groov RIO.
Terry uses a groov RIO as a means of gathering physical I/O inputs and outputs. Opto 22's groov RIO is edge I/O for the IIoT: standalone industrial I/O that collects and securely publishes data from field to cloud. https://www.opto22.com/products/groov...
Watch the intro to the MySQL Node-RED nodes video:
• Basic Intro to MySQL Node-RED Nodes w...
Chapters:
0:00 Intro
1:50 Explore MySQL from Node-RED
4:27 Gather Data from Node-RED Dashboard
18:00 Creating an Insert Statement
21:32 Testing an Insert Statement
26:26 Gather Data from Physical Inputs
43:33 Display MySQL Data with the Table Node
Learn more at:
Opto 22 forums: https://forums.opto22.com/
groov IO node video: • Setting Up groov IO Nodes in Node-RED
groov IO nodes: https://flows.nodered.org/node/node-r...
Node-RED dashboard UI introduction video: • Tutorial: Basic Node-RED Dashboard UI
Node-RED dashboard UI nodes: https://flows.nodered.org/node/node-r...
Node-RED dashboard UI table node: https://flows.nodered.org/node/node-r...
More Info
groov RIO: https://www.opto22.com/products/groov...
http://developer.opto22.com/nodered/g...
https://www.opto22.com/
https://forums.opto22.com/
For more free training checkout:
https://training.opto22.com/
All Opto 22 products are designed, manufactured, and supported in the U.S.A. from our Temecula, California headquarters and factory.
#nodered #tutorial
