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
ESP32, MQTT and SQL
-
- Posts: 9764
- Joined: Thu Nov 26, 2015 4:08 am
Re: ESP32, MQTT and SQL
It's actually far from obvious, as you're not asking any questions in the text aboveSorry if the question is too obvious
Re: ESP32, MQTT and SQL
The question is which of these two second is more recommendable
-
- Posts: 9764
- Joined: Thu Nov 26, 2015 4:08 am
Re: ESP32, MQTT and SQL
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 13 guests