Advanced NodeRED amp MySQL tips and techniques

YOUR LINK HERE:

http://youtube.com/watch?v=xwLTby6b-IU

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

#############################

New on site