Page 1 of 1

ESP32, MQTT and SQL

Posted: Tue Nov 03, 2020 11:37 pm
by dopelemon
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

Re: ESP32, MQTT and SQL

Posted: Wed Nov 04, 2020 2:11 am
by ESP_Sprite
Sorry if the question is too obvious
It's actually far from obvious, as you're not asking any questions in the text above :)

Re: ESP32, MQTT and SQL

Posted: Wed Nov 04, 2020 10:19 am
by dopelemon
The question is which of these two second is more recommendable

Re: ESP32, MQTT and SQL

Posted: Thu Nov 05, 2020 12:34 am
by ESP_Sprite
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.