Book Image

Arduino Data Communications

By : Robert Thas John
5 (1)
Book Image

Arduino Data Communications

5 (1)
By: Robert Thas John

Overview of this book

In our modern, internet-connected world, where billions of devices constantly collect and send data to systems to be stored and processed, it’s surprising how the intricacies of data transmission and storage are often overlooked in the IoT domain. With Arduino Data Communications, you'll bridge the knowledge gap and become an expert in collecting data from IoT sensors, transmitting data, and configuring your own databases. This book is an exploration of IoT’s inner workings, guiding you through the process of setting up an end-to-end system that you can employ to prototype your own IoT solutions, using easy-to-follow examples. It begins with a general overview of the Arduino ecosystem, acquainting you with various sensors and shields and unveiling the art of data collection. You’ll then explore data formats and methods to store data, both locally and on database servers. As you progress through the chapters, you’ll learn how to set up REST and MQTT infrastructure to communicate with databases and get hands-on with LoRaWAN, Ethernet, cellular, HC-12, and RS-485. The final chapters are your training ground for real-world projects, imparting the essential knowledge you need to tackle complex challenges with confidence. By the end of this Arduino book, you'll have seamlessly configured an end-to-end system, all while immersing yourself in practical scenarios that bring the world of IoT to life.
Table of Contents (20 chapters)
Part 1:Introduction to Arduino and Sensor Data
Part 2:Sending Data
Part 3: Miscellaneous Topics

Working with SQL

Creating tables in SQL falls into a class of operations called data definition language (DDL). However, working with data falls into a class called data manipulation language (DML). DML falls into four categories that are frequently called create, retrieve, update, and delete (CRUD). Let’s take a brief look at CRUD.

Project 2 – Inserting data into a MySQL table

We must create operations and insert data into a table. This uses an INSERT statement in SQL. The script for this project is available at

Follow these steps to insert data into the tables:

  1. Log into the remote server using the following shell command, making sure you replace the IP address with your server’s:
    ssh [email protected]
  2. Log into MySQL using the following shell command, making sure you replace the username with the appropriate value: