The industry data is playing a significant role in the decision-making process. It is very important to know how to fetch data from the shop floor and convert it into information. There are thousands of sensors on the shop floor which are reading data from the process every millisecond. As a PLC Programmer, we know we cannot store all the information in the PLC memory as it has some limitations. To store the data from the last 5-10 years or more, we need an external database.
In this course, you will learn how to store the data from Siemens S7-1200 PLC or any other controller in an external database like MySQL with the help of Node-RED. You will learn how to search, insert, update, or delete data from the database via Node-RED programming.
The following are the pre-requisite for this course:
- Basics of Node-RED
- Node-RED interfacing with PLC, Arduino, or Raspberry pi
- Node-RED and MySQL installation in the computer with internet
- Any controller- Arduino, Raspberry pi, or PLC to read the real-world data or FACTORY IO
StartPractice with me :)
PreviewHow to INSERT values in the database via query (5:20)
StartHow to SELECT values in the database via query (8:31)
StartHow to UPDATE values in the database via query (5:18)
StartHow to DELETE values in the database via query (4:20)
StartWant to learn more SQL Queries?
StartHow to connect Node-RED to MySQL (8:10)
StartHow to execute SELECT and INSERT query via Node-RED (7:57)
StartHow to execute INSERT query via Form in Node-RED (11:14)
StartHow to view information on the table in Node-RED (11:29)
StartHow to execute UPDATE and DELETE query via Node-RED (19:42)
Rajvir is a Mechatronics Engineer & passionate educator. As an engineer, he is involved in control circuit designing and flexible course designing in various elements of automation like PLC, PID, HMI & Drives- VFD & Servo, Connect I/O, Home I/O, and Factory Automation.
As a teacher, he loves to implement innovative 3D-Learning methods to make education easy & interesting. He teaches Industrial Automation to almost 167+ countries across the world.
He loves to meet professors, teachers, educators, instructors to discuss & share Innovative tools of learning technology.
You can contact him at [email protected] if you share a similar interests & would like to work for a social mission of creating a better education system