ESP32, MQTT and SQL

[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

[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

[dopelemon]

The question is which of these two second is more recommendable

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