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 these.
Thanks very much in advance
