OptoBlog

Advanced techniques to move data with Node-RED and MySQL

Posted by Janice Colmer on Aug 10, 2021 3:01:25 PM

A new video has just been added to the Node-RED developer series that takes a closer look at MySQL database nodes.

Have you been watching our Node-RED video series? If you're an NR user or want to become one, you don't want to miss out on Terry Orchard's tutorials. His latest video will unlock your honest-to-goodness Node-RED superpowers with step-by-step instructions on moving user inputs and device signal data into and out of a MySQL database.

A lot of Node-RED projects are built around the fact that you need to move information from one data source to another. It could be something like a user interface, which Terry has covered before, but databases are a very popular and useful endpoint as well. And why not do both? Node-RED makes it easy!

In this new video, Terry gives you the specifics on how to use MySQL nodes and supporting code to craft INSERT statements that pull data into MySQL from your NR dashboard and groov device I/O.

Finally, you'll see how to pull data back into the flow and display it in a Node-RED dashboard table that is running on a
groov RIO. Watch and learn.

Advanced techniques to move data with Node-RED and MySQL

For more lessons and tips on Node-RED, check out these other developer resources:

And thanks for watching!

Topics: Node-RED, groov RIO, MySQL

Written by Janice Colmer

Janice has worked at Opto 22 for nearly 20 years and is part of the marketing team that strives to share new and relevant content with the automation industry. She enjoys books, camping, country music, and spending time with family and friends.
Find me on:

    Subscribe to Email Updates

    Recent Posts

    Posts by Topic

    see all