Factory Automation
Home Improvement
Software
Node-RED SQL Database Log - Modbus Logging
6K views
·
Oct 12, 2022
Node-RED can easily log data to a database. SQL (Structured Query Language) can be used to communicate to a SQL database. Databases separate analysis from the data unlike spreadsheets like Excel. The database is designed to hold more information than spreadsheets and allow multiple users to access the information.
We will be creating an SQLite SQL database. SQLite Studio will be used to design the structure of the database. (Tables) Installing the node-red-sqlite-node palette will allow us to log the information from our Solo process temperature controller, Click PLC, and dashboard variables. Let’s get started.
More information can be obtained at our website. This includes all of the links mentioned in this video. https://accautomation.ca/node-red-sql-database-log-modbus-logging/
In this series we started using Node-RED in some of the following ways:
Installing the Windows Software
https://accautomation.ca/node-red-installing-the-windows-software/
https://youtu.be/xGzH2Hv31WA
Modbus RTU / TCP Communication
https://accautomation.ca/node-red-modbus-rtu-tcp-communication/
https://youtu.be/yX1w5vcV6cc
User Interface - Dashboards
https://accautomation.ca/node-red-user-interface-dashboards/
https://youtu.be/8zAG2wXwGOc
We will continue with the following:
Log information into a database
View information in the database through spreadsheets such as Excel.
00:00 Node-RED SQL Database Log
01:28 Download/Install SQLite
02:32 Download/Install SQLite Studio
03:22 SQLite Studio Create Database
08:53 Node-RED SQLite Install
09:54 Node-RED SQL Database Log Program
12:04 Node-RED Database Program Run
There are several reasons why we are using Node-RED. Here are just a few.
- Built on top of the most dependable programming language JavaScript.
- JavaScript is flexible and easy to work with on web browsers, server-side, IoT, IIoT projects, and more.
- Visual flow type interface making programming easy.
- Node will allow JavaScript code to run directly on a computer.
- Node-RED is a free, open-source logic engine.
- Connect to PLC, PAC, Temperature Controllers, Process Controllers using standard protocols.
- Save and read from databases
- Easily make the Internet of Things (IoT, IIoT) industrial solutions.
Node-RED provides the ability for you to quickly create custom control solutions.
https://www.accautomation.ca
Show More
Show LessComments
loading text loading
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text