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-rio

Watch the intro to the MySQL Node-RED nodes video:
https://www.youtube.com/watch?v=kIylVo8fxYY

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: https://www.youtube.com/watch?v=J8nSswbK8J8
groov IO nodes: https://flows.nodered.org/node/node-red-contrib-groov-io
Node-RED dashboard UI introduction video: https://www.youtube.com/watch?v=Ho1vMuA43ks
Node-RED dashboard UI nodes: https://flows.nodered.org/node/node-red-dashboard
Node-RED dashboard UI table node: https://flows.nodered.org/node/node-red-node-ui-table

More Info
groov RIO: https://www.opto22.com/products/groov-rio
http://developer.opto22.com/nodered/general/
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