ESP32 data logging on webserver?

Other Hardware Storage
1

Hi everyone. Before I start I am a noob so please be considerate.

SW Architecture
SW Architecture1357×318 39.7 KB

This is the system I am working with. ESP32 is the server and there are 2 Arduinos. The first arduino manages LoRa communication and initiates contact with remote controller. It also transmits sensor data from ESP32 and IMU information from the remote controller to ESP32.
The second arduino is just a remote controller that moves the system as desired.

rf overview
rf overview1350×662 58.9 KB

The UI (screen) shows temperate data at the current time. The UI is hosted on a web server, and the system can be controlled either through the website or remote controller (based on user choice).

My question is:

Without changing the current setup, what are possible options for both long-term and real-time data logging?
The user should have current data displayed on the screen as well as be able to access all previous readings with timestamps - for data analysis. Additionally, I plan to store all data on the SD card. Is it possible to create data storage on the webserver?
Researching online I saw GoogleSheets, WebSockets, etc. However, I am! NOT ALLOWED! to use hosted / subscription-based cloud storage.
What about FreeRTOS?

I am utterly lost please someone help.

2

Implement a webserver on the ESP32 and save the data there. Use jquery(plain html/... for gui

3

I assume you are running the web server on the ESP32. It could also be user for data storage. If the data to be stored is a few MB or less part of the flash memory could be used via LittleFS with no need for the SD card. I usually include web pages to list the files and select a file for download. Here is an example that is a bit dated now. It can still give you some ideas.

4

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.