# ersabby/webserver architecture

> Architecture diagram of the GitHub repository ersabby/webserver, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-21). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/ersabby/webserver
- Repository: https://github.com/ersabby/webserver

## Overview

The project collects DHT11 readings through an ESP32 and MQTT, then offers two visible server-side paths: a Flask page backed by SQLite, and a Node MQTT subscriber that stores messages in MySQL. The README establishes the sensor-to-MQTT product workflow; the excerpts show the server-side subscriptions, persistence and page rendering. The Grafana directory contains no shown dashboard code, so it is represented only by the evidenced Node ingestion and storage behavior.

Main entry points: [`webserver/DHT-server/code.py`](https://github.com/ersabby/webserver/blob/master/webserver/DHT-server/code.py) (Flask MQTT and web app), [`webserver/Grafana/index.js`](https://github.com/ersabby/webserver/blob/master/webserver/Grafana/index.js) (MQTT subscriber), [`webserver/esp32_DHT11.ino`](https://github.com/ersabby/webserver/blob/master/webserver/esp32_DHT11.ino) (ESP32 firmware), [`webserver/DHT-server/sensordata.db`](https://github.com/ersabby/webserver/blob/master/webserver/DHT-server/sensordata.db) (Sensor readings)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_device["Sensing device"]
  node_dht["DHT11 sensor"]
  node_esp32["ESP32 firmware<br/>[esp32_DHT11.ino]"]
end

subgraph group_flask["Flask service"]
  node_flask_app["Flask MQTT and web app<br/>[code.py]"]
  node_sqlite[("Sensor readings<br/>[sensordata.db]")]
  node_page["Readings page<br/>[main.html]"]
end

subgraph group_node["Node ingestion"]
  node_node_subscriber["MQTT subscriber<br/>[index.js]"]
  node_mysql[("MySQL messages")]
end

node_user(("Web user"))
node_mqtt["MQTT broker"]

node_dht -->|"provides readings"| node_esp32
node_esp32 -->|"publishes readings"| node_mqtt
node_flask_app -->|"subscribes to dht"| node_mqtt
node_mqtt -->|"delivers messages"| node_flask_app
node_flask_app -->|"writes readings"| node_sqlite
node_user -->|"requests page"| node_flask_app
node_flask_app -->|"reads latest"| node_sqlite
node_flask_app -->|"renders readings"| node_page
node_node_subscriber -->|"subscribes to dht"| node_mqtt
node_mqtt -->|"delivers messages"| node_node_subscriber
node_node_subscriber -->|"inserts messages"| node_mysql

click node_esp32 "https://github.com/ersabby/webserver/blob/master/webserver/esp32_DHT11.ino"
click node_flask_app "https://github.com/ersabby/webserver/blob/master/webserver/DHT-server/code.py"
click node_sqlite "https://github.com/ersabby/webserver/blob/master/webserver/DHT-server/sensordata.db"
click node_page "https://github.com/ersabby/webserver/blob/master/webserver/DHT-server/templates/main.html"
click node_node_subscriber "https://github.com/ersabby/webserver/blob/master/webserver/Grafana/index.js"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_dht,node_esp32,node_user toneBlue
class node_flask_app,node_sqlite,node_page toneAmber
class node_node_subscriber,node_mysql toneMint
class node_mqtt toneIndigo
```

## Components

### Sensing device

- **DHT11 sensor**
- [ESP32 firmware](https://github.com/ersabby/webserver/blob/master/webserver/esp32_DHT11.ino): `webserver/esp32_DHT11.ino`

### Flask service

- [Flask MQTT and web app](https://github.com/ersabby/webserver/blob/master/webserver/DHT-server/code.py): `webserver/DHT-server/code.py`
- [Sensor readings](https://github.com/ersabby/webserver/blob/master/webserver/DHT-server/sensordata.db): `webserver/DHT-server/sensordata.db`
- [Readings page](https://github.com/ersabby/webserver/blob/master/webserver/DHT-server/templates/main.html): `webserver/DHT-server/templates/main.html`

### Node ingestion

- [MQTT subscriber](https://github.com/ersabby/webserver/blob/master/webserver/Grafana/index.js): `webserver/Grafana/index.js`
- **MySQL messages**

### Other components

- **Web user**
- **MQTT broker**

## Connections

- DHT11 sensor → ESP32 firmware: provides readings (evidence: `README.md`)
- ESP32 firmware → MQTT broker: publishes readings (evidence: `README.md`)
- Flask MQTT and web app → MQTT broker: subscribes to dht (evidence: `webserver/DHT-server/code.py`)
- MQTT broker → Flask MQTT and web app: delivers messages (evidence: `webserver/DHT-server/code.py`)
- Flask MQTT and web app → Sensor readings: writes readings (evidence: `webserver/DHT-server/code.py`)
- Web user → Flask MQTT and web app: requests page (evidence: `webserver/DHT-server/code.py`)
- Flask MQTT and web app → Sensor readings: reads latest (evidence: `webserver/DHT-server/code.py`)
- Flask MQTT and web app → Readings page: renders readings (evidence: `webserver/DHT-server/code.py`)
- MQTT subscriber → MQTT broker: subscribes to dht (evidence: `webserver/Grafana/index.js`)
- MQTT broker → MQTT subscriber: delivers messages (evidence: `webserver/Grafana/index.js`)
- MQTT subscriber → MySQL messages: inserts messages (evidence: `webserver/Grafana/index.js`)
