How jankd90/databases works
This is an ESP32 climate-station project paired with a host-side SQLite receiver and a guided database course. The runtime workflow is sensor measurement, WiFi transmission, host parsing, and SQLite persistence; the tutorials extend the same project through schema design, SQL analysis, and a Python application. Runtime edges are supported by the README and excerpts. Tutorial internals are represented by their exact directories because their source was not sampled.
Main entry points: LeesESP32_SQlite.py Climate SQLite DB · 01_db_design Schema Design · 03_climate_analysis Climate Analysis · boot.py WiFi Setup
Components 16
ESP32 Device
- WiFi Setup
esp32-code/boot.py - WiFi Credentials
esp32-code/secure.txt - BME280 Driver
esp32-code/bme280.py - ESP32 Sender
esp32-code/main.py
Host Ingestion
- Host Receiver
LeesESP32_SQlite.py - Climate SQLite DB
LeesESP32_SQlite.py
Database Tutorials
- Schema Design
tutorials/01_db_design - SQL Work
tutorials/02_sql_real_work - Climate Analysis
tutorials/03_climate_analysis - SQLite Application
tutorials/04_sqlite_application - Windows Setup
tutorials/00_windows_setup
Course Materials
- Course Reader
Course-reader-lab-manual.md - Climate Chapters
docs
Other components
- BME280 Sensor
- WiFi Network
- ChartDB
Connections 14
- WiFi Setup → WiFi Credentials: reads credentials
README.md - WiFi Setup → WiFi Network: connects to
README.md - BME280 Sensor → BME280 Driver: provides readings
- ESP32 Sender → BME280 Driver: reads measurements
esp32-code/main.py - ESP32 Sender → Host Receiver: sends readings
README.md - Host Receiver → Climate SQLite DB: parses and stores
LeesESP32_SQlite.py - ChartDB → Schema Design: supports design
README.md - Schema Design → SQL Work: continues project
README.md - SQL Work → Climate Analysis: continues project
README.md - Climate Analysis → SQLite Application: continues project
README.md - Climate SQLite DB → Climate Analysis: provides readings
README.md - Climate SQLite DB → SQLite Application: supports app
README.md - Windows Setup → Schema Design: prepares learners
README.md - Course Reader → Climate Chapters: course materials