Скачать с ютуб 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