Raw data
The raw data from the sensors is being processed by each sensor’s dedicated ESP8266 microcontroller before it is posted via WiFi to a webpage which is responsible for posting the data to a SQL database where it is saved for further processing.
Data processing on Raspberry Pi
The Raspberry Pi 4 which is running the SQL server where all the data is stored is also responsible for processing the data before it is displayed on the website. That is done by Python scripts and Cron jobs. Every once in a while a Cron job makes sure that a certain script is run and thereby updating the relevant data on the SQL server which is then available to the webpage displaying the data.
Dashboard
I call the webpage where I display all the data the dashboard or just dash. The dash checks for new data on the SQL server every 10 seconds by dynamically updating the page via a java script library called jQuery. The dash can be accessed via this link https://weather.jorgre.dk/dash/ or in the top menu.