In this video we take a deep dive into the MySQL database nodes to insert data into and select data from a MariaDB server. 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.
groov RIO: https://www.opto22.com/products/groov-rio
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