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

Click Plus Establish Communication

Click Plus Establish Communication

We will now establish communication using four different methods from our computer to the new Click Plus controller. The click programming software version 3.00 will be used for the communication methods. Click Plus controllers allow you to program them through the micro USB port on every CPU. WiFi (Bluetooth Provisioning) is also available on some … Read more