Advanced Node-RED & MySQL tips and techniques

Описание к видео 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

Комментарии

Информация по комментариям в разработке