You're reading from Building IoT Visualizations using Grafana Power up your IoT projects and monitor with Prometheus, LibreNMS, and Elasticsearch

Product type Paperback

Published in Jul 2022

Publisher Packt

ISBN-13 9781803236124

Length 360 pages

Edition 1st Edition

Tools

Elasticsearch

Concepts

IoT Development

Author (1):

Rodrigo Juan Hernandez

View More author details

Table of Contents (21) Chapters

Preface

1. Part 1: Meeting Grafana

2. Chapter 1: Getting Started with Grafana FREE CHAPTER

3. Chapter 2: Exploring Grafana

4. Part 2: Collecting Data from IoT Devices

5. Chapter 3: Connecting IoT Devices

6. Chapter 4: Data Sources for Grafana

7. Chapter 5: Using Time Series Databases

8. Part 3: Connecting Data Sources and Building Dashboards

9. Chapter 6: Getting Data and Building Dashboards

10. Chapter 7: Managing Plugins

11. Chapter 8: Organizing and Managing Dashboards

12. Part 4: Performing Analytics and Notifications

13. Chapter 9: Performing Analytics in Grafana

14. Chapter 10: Alerting and Notifications in Grafana

15. Part 5: Integrating Grafana with Other Platforms

16. Chapter 11: Using Grafana with Prometheus

17. Chapter 12: Using Grafana with OpenSearch

18. Chapter 13: Showing Data from LibreNMS in Grafana

19. Chapter 14: Integrations for Grafana Cloud

20. Other Books You May Enjoy

SQL versus NoSQL databases

In this section, we will explore these two types of databases and define their characteristics and differences. Learning about databases is crucial to understanding how to manage, query, and process data in the context of Grafana.

Let’s start with SQL databases.

SQL databases

This type of database was invented in the 1970s, and it is widely used today.

A relational database management system (RDBMS) is a system that manages data according to a relational model. This type of database represents data in tables, where each of the rows has a unique ID, called an index or ID. This field serves to relate the information among the tables.

Imagine you have a user database for accessing a web application. One table can store all the information that belongs to a specific user. Another table can have the permissions granted to each user. In this case, the user ID is the link between both tables. So, you can relate each user with the corresponding...