Click Plus Data Logging – CSV File SQL Database

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 … Read more

Node-RED SQL Database Spreadsheet Connection

Node-RED SQL Database Spreadsheet Connection

We will now look at the connection to our SQL database using a spreadsheet application. Previously we used Node-RED to communicate Modbus TCP and RTU to our Click PLC and Solo Temperature Controller. The information collected from the controllers was then put into an SQLite SQL database. Spreadsheets like Excel are great for analysis of … Read more

Arduino Uno Super Starter Kit Ultrasonic Sensor

Arduino Uno Super Starter Kit Ultrasonic Sensor

The ultrasonic sensor (HC-SR04) is great for all kinds of projects that need distance measurements. The HC-SR04 is inexpensive and easy to use. We will be sending signals directly to the sensor and interpreting the results without the need for a library. Ultrasonic sensor module HC-SR04 provides a 2cm-400cm non-contact measurement function, the accuracy can … Read more

Click Plus PLC MQTT Communication

Click Plus PLC MQTT Communication

We will now look at the MQTT communication capability using our Click plus PLC. MQTT stands for Message Queuing Telemetry Transport. This simple ‘publish and subscribe’ communication protocol, does not take too many resources. Constrained devices with low bandwidth are ideal for MQTT. This protocol provides machine-to-machine (M2M) connectivity which is ideal for the Internet … Read more

Node-RED SQL Database Log – Modbus Logging

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 … Read more

Arduino Uno Super Starter Kit Servo

Arduino Uno Super Starter Kit Servo

The servomotor, RC (Hobby) Servo is a type of gear motor that can only rotate 180 degrees. It is controlled by sending electrical pulses from our UNO R3 board. These pulses tell the servo what position it should move to. We will be wiring the servo to our Arduino UNO R3 controller on our super … Read more