Premium Only Content

Node-RED SQL Database Log - Modbus Logging
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/
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.
-
4:17:17
VapinGamers
5 hours ago $1.25 earned📣 Fortnite Family Night! - Games and Dubs with BrianZGame - !rumbot
22.9K1 -
LIVE
ThePope_Live
4 hours agoLIVE - First time playing The Finals in over a YEAR! Still good? with @Arrowthorn
132 watching -
3:06:26
TruthStream with Joe and Scott
9 hours agoRoundtable with Patriot Underground and News Treason Live 4/26 5pm pacific 8pm Eastern
31.8K24 -
8:52
Tundra Tactical
7 hours ago $8.27 earnedSCOTUS Denies Appeal, Minnesota Courts Deal 2a Win!
38.3K8 -
LIVE
a12cat34dog
9 hours agoONE WITH THE DARK & SHADOWS :: The Elder Scrolls IV: Oblivion Remastered :: FIRST-TIME PLAYING {18+}
848 watching -
22:27
Exploring With Nug
16 hours ago $12.16 earnedSwamp Yields a Chilling Discovery in 40-Year Search for Missing Man!
52.3K17 -
1:23:26
RiftTV/Slightly Offensive
11 hours ago $10.96 earnedThe LUCRATIVE Side of Programming and the SECRETS of the "Tech Right" | Guest: Hunter Isaacson
61.9K16 -
27:57
MYLUNCHBREAK CHANNEL PAGE
1 day agoDams Destroyed India
69.1K24 -
LIVE
Phyxicx
11 hours agoLast minute practice before Sunday - 4/26/2025
169 watching -
LIVE
The Official Steve Harvey
10 days ago $4.99 earned24 HOURS OF MOTIVATION w/ STEVE HARVEY
71 watching