Advanced Node-RED & MySQL Tips and Techniques

Dive deep into advanced Node-RED and MySQL techniques in this 49-minute video tutorial. Learn how to insert data into and select data from a MariaDB server using MySQL database nodes. Explore two different methods for data insertion: using locally saved context variables within Node-RED and building up similar data in a single message object. Discover how to select data back into the flow and display it in a Node-RED dashboard table running on a groov RIO. Follow along as the instructor demonstrates gathering physical I/O inputs and outputs using Opto 22's groov RIO, an edge I/O device for IIoT. Gain practical insights through step-by-step explanations of exploring MySQL from Node-RED, gathering data from the Node-RED dashboard, creating and testing insert statements, collecting data from physical inputs, and displaying MySQL data with the table node.

Intro
Explore MySQL from Node-RED
Gather Data from Node-RED Dashboard
Creating an Insert Statement
Testing an Insert Statement
Gather Data from Physical Inputs
Display MySQL Data with the Table Node