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/ 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.