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 to this field and I have had 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 th