You're reading from Arduino Data Communications Learn how to configure databases, MQTT, REST APIs, and store data over LoRaWAN, HC-12, and GSM

Product type Paperback

Published in Nov 2023

Publisher Packt

ISBN-13 9781837632619

Length 286 pages

Edition 1st Edition

Tools

Arduino

Concepts

Embedded Systems

Author (1):

Robert Thas John

View More author details

Table of Contents (20) Chapters

Preface

1. Part 1:Introduction to Arduino and Sensor Data

2. Chapter 1: Getting Started with Arduino FREE CHAPTER

3. Chapter 2: Leveraging Various Sensors for Data Acquisition

4. Chapter 3: Prototyping with Shields

5. Chapter 4: Storing Data Collected from Sensors

6. Chapter 5: Implementing REST and MQTT Protocols for Communication

7. Part 2:Sending Data

8. Chapter 6: Utilizing Various Communication Technologies

9. Chapter 7: Communicating with LoRaWAN

10. Chapter 8: Working with Ethernet

11. Chapter 9: Leveraging Cellular Communication Technology

12. Chapter 10: Communicating via HC-12

13. Chapter 11: Managing Communication with RS-485

14. Part 3: Miscellaneous Topics

15. Chapter 12: Enhancing Security for Reducing Risk

16. Chapter 13: Scaling for High Availability

17. Chapter 14: Building and Manufacturing Hardware

18. Index

Why subscribe?

19. Other Books You May Enjoy

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...