ESP32, MQTT and SQL

dopelemon
Posts: 6
Joined: Mon Nov 02, 2020 7:00 pm

ESP32, MQTT and SQL

Postby dopelemon » Tue Nov 03, 2020 11:37 pm

I am carrying out a personal project that consists of a sensor station through the esp32 microprocessor. I need to store the collected data in a database for later analysis and also to see the information in real time. I am new in this field and I think two options:
-Use MQTT for its simplicity to communicate the microprocessor with the broker and from there to the SQL database. In this way I would obtain the data in real time
-Use SQL directly from the microprocessor itself.

Sorry if the question is too obvious, although feel free to explain the different options in addition to these.

Thanks very much in advance :D :D

ESP_Sprite
Posts: 9764
Joined: Thu Nov 26, 2015 4:08 am

Re: ESP32, MQTT and SQL

Postby ESP_Sprite » Wed Nov 04, 2020 2:11 am

Sorry if the question is too obvious
It's actually far from obvious, as you're not asking any questions in the text above :)

dopelemon
Posts: 6
Joined: Mon Nov 02, 2020 7:00 pm

Re: ESP32, MQTT and SQL

Postby dopelemon » Wed Nov 04, 2020 10:19 am

The question is which of these two second is more recommendable

ESP_Sprite
Posts: 9764
Joined: Thu Nov 26, 2015 4:08 am

Re: ESP32, MQTT and SQL

Postby ESP_Sprite » Thu Nov 05, 2020 12:34 am

As usual, everything depends on the circumstances, but in this case I'd probably go the MQTT route. MQTT is used a lot more on the ESP32 than a connector to whatever database you have, so you're bound to run into fewer issues.

Who is online

Users browsing this forum: No registered users and 15 guests