Tag Archives: node red sql

Click Plus Data Logging – CSV File SQL Database


We will now look at the data logging capability using our Click plus PLC.
Data logging is the collection of data over time. This is usually used for data analysis at a later time. The amount of data (System Information) stored and the frequency of the storage will depend on your specific application.

The hardware used to store the data is usually called a data logger. Using the information from our last post, the MQTT information collected (Temperature in Atlanta and Click Analog) will now be logged in two different ways. A micro SD card on the Click Plus will be used to store the data every minute in a CSV (Comma Separated Value) file. Node-RED will also be used to store the same data in a SQL database. Let’s get started on how to use these data loggers. Keep on Reading!

ACC Automation 2020 Yearly Review


Accelerate Learning …
Accelerate Machines…
Accelerate Knowledge…
ACC Automation

What a difference a year makes! Social distancing, mask-wearing, hygiene, social circles, etc are just a few of the terms we hear every day in this Covid-19 world. Video conferencing with Zoom, Teams, and Google Meet are the norm in business today. Information is knowledge, and everyone wants to be able to see, control, and summarize production data on a regular basis. Technologies are merging and communicating like never before. What was impossible is now possible for the industrial plant floor. We are looking forward to the New Year and new possibilities for implementing your control solution.

Each year we like to take a few minutes and reflect on the past, current, and future of ACC Automation. You have helped us to build the site that you see today through questions, comments, and suggestions. Thank you. Keep on Reading!