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 REST

Most DBMSs will ship with an interface that makes it possible to interact with the server, type in commands, and get responses. You have seen this at play when logging into the server remotely and typing in mysql from the command line.

REST makes it possible to communicate with an application server over HyperText Transfer Protocol (HTTP), which, in turn, communicates with a DBMS using any native technology that is supported. HTTP and HTTPS are normally the first part of most URLs that you type into the address bar of a browser. HTTPS is HTTP with a secure component.

Both HTTP and HTTPS tell the browser how to communicate with the server that it is connecting to. Most DBMSs are not designed to work with HTTP or HTTPS, so we will need to set up a separate component (called middleware) that will communicate with the DBMS while exposing an HTTP or HTTPS interface.

Before we do that, let’s set up some tables within the telemetry schema in our MySQL database...