Uploaded September 2025 | Updated September 2026, 2 weeks ago
***********************************************
Follow and contact me on Instagram : instagram.com/utehstr
***********************************************
***********************************************
ARDUINO IDE + ESP32 + SQLite (SQLite3) + Micro SD Card Module + DHT11 Sensor + DS3231 RTC Module.
- Getting Started ESP32 with SQLite (SQLite3) Database.
- Data Logging with ESP32 and SQLite (SQLite3) Database and Web Server.
Software used :
- Arduino IDE (V1.8.19).
- DB Browser for SQLite (V3.13.1).
Arduino core :
- Arduino core for the ESP32 (V2.0.16) / ESP32 board in Arduino IDE.
Arduino libraries used :
- Sqlite3Esp32 by Arun (V2.5.0).
- RTClib by Adafruit (V2.1.4).
- LiquidCrystal_I2C by Marco Schwartz (V1.1.4).
- DHT sensor library by Adafruit (V1.4.6).
- Async TCP by ESP32Async (V3.4.4).
- ESP Async WebServer by ESP32Async (V3.7.7).
Hardware used :
- ESP32 DEVKIT V1.
- MicroSD Card Module.
- MicroSD Card (2 GB).
- RTC DS3231 Module.
- DHT11 Sensor Module.
- LCD 20x4 I2C.
- And other equipment such as cables, power supplies and others.
Timestamp :
00:00 Opening
00:32 Project Preview
02:23 Installation image
02:33 Software and arduino libraries and more
02:54 Formatting the Micro SD card
03:36 Creating a database file and its table
06:53 Test ESP32 with SQLite Database via Serial
09:03 Test ESP32 with SQLite Database via Serial - Demo
11:14 Test DHT11 Sensor and RTC DS3231
12:48 Test DHT11 Sensor and RTC DS3231 - Demo
14:22 ESP32 SQLite Data Logging Web Server (APM)
18:10 ESP32 SQLite Data Logging Web Server (APM) - Demo
22:14 ESP32 SQLite Data Logging Web Server (SM)
24:48 ESP32 SQLite Data Logging Web Server (SM) - Demo
26:10 Closing
***********************************************
Download the project files (program code files and other files) here : drive.google.com/file/d/15RMmdRwCuf1ltp9-VjUi0M4BRXqqvbk-/view?usp=sharing
The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.
***********************************************
SORRY IF MY ENGLISH IS CONFUSING, I USE AN ONLINE TRANSLATOR.
THANKS FOR WATCHING & DON'T FORGET TO LIKE , SHARE, COMMENT AND SUBSCRIBE.
***********************************************
For other video tutorials on this channel, please see this playlist:
- Basic4Android (B4A) Tutorials : youtube.com/watch?v=-BIq32-qEgA&list=PLnXsmScWzcm6RVlhPM7qg_OJ2N8OpV99d
- Electronics Tutorials : youtube.com/watch?v=rLdsWt6EP6w&list=PLnXsmScWzcm766h5Dn4AJjbJRzDfCPh4h
- Arduino Tutorials : youtube.com/watch?v=A3_EBZqCG5s&list=PLnXsmScWzcm48hvcTTRAUFcP5Fjd4u8cS
- Great Cow Basic Tutorials : youtube.com/watch?v=orHrLmEvp0o&list=PLnXsmScWzcm7xejzacm5cKJMIh_tXXxN8
- Bascom Avr Tutorials : youtube.com/watch?v=JYKSkNQq9eM&list=PLnXsmScWzcm6F9gX1wYenqjKdqVSM7d6B
- VB .NET Tutorials : youtube.com/watch?v=Sy2vjWO0ydM&list=PLnXsmScWzcm4g8AWEJ6WXVUOBh_cWF5_z
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : youtube.com/watch?v=8jMr94B8iN0&list=PLnXsmScWzcm5MERfTvcUNKsYhOUGKe3-V
- ESP32 Tutorials : youtube.com/watch?v=To3TIOFX6cA&list=PLnXsmScWzcm7Y5yCDItJP5Kny_MJ8DeDD
- ESP32 CAM Tutorials : youtube.com/watch?v=_5VmYJZI4XI&list=PLnXsmScWzcm6HjC0CIfVmRG1855tjhj5z
***********************************************
Links to download the software and libraries used and further information are available in the program code.
***********************************************
References :
- Sqlite3 Arduino library for ESP32 : github.com/siara-cc/esp32_arduino_sqlite3_lib
- SQLite3 ESP32 Web Server : github.com/FakirMaker/SQLite3-ESP32-Web-Server
- ESP32 Datalogger - Download Data File via Web Server :
randomnerdtutorials.com/esp32-datalogger-download-data-file
- JavaScript Timing Events : w3schools.com/js/js_timing.asp
- JavaScript String split : w3schools.com/jsref/jsref_split.asp
- The complete reference list can be seen in the program code file.
***********************************************
***********************************************
Follow and contact me on Instagram : instagram.com/utehstr
***********************************************
***********************************************
ARDUINO IDE + ESP32 + SQLite (SQLite3) + Micro SD Card Module + DHT11 Sensor + DS3231 RTC Module.
- Getting Started ESP32 with SQLite (SQLite3) Database.
- Data Logging with ESP32 and SQLite (SQLite3) Database and Web Server.
Software used :
- Arduino IDE (V1.8.19).
- DB Browser for SQLite (V3.13.1).
Arduino core :
- Arduino core for the ESP32 (V2.0.16) / ESP32 board in Arduino IDE.
Arduino libraries used :
- Sqlite3Esp32 by Arun (V2.5.0).
- RTClib by Adafruit (V2.1.4).
- LiquidCrystal_I2C by Marco Schwartz (V1.1.4).
- DHT sensor library by Adafruit (V1.4.6).
- Async TCP by ESP32Async (V3.4.4).
- ESP Async WebServer by ESP32Async (V3.7.7).
Hardware used :
- ESP32 DEVKIT V1.
- MicroSD Card Module.
- MicroSD Card (2 GB).
- RTC DS3231 Module.
- DHT11 Sensor Module.
- LCD 20x4 I2C.
- And other equipment such as cables, power supplies and others.
Timestamp :
00:00 Opening
00:32 Project Preview
02:23 Installation image
02:33 Software and arduino libraries and more
02:54 Formatting the Micro SD card
03:36 Creating a database file and its table
06:53 Test ESP32 with SQLite Database via Serial
09:03 Test ESP32 with SQLite Database via Serial - Demo
11:14 Test DHT11 Sensor and RTC DS3231
12:48 Test DHT11 Sensor and RTC DS3231 - Demo
14:22 ESP32 SQLite Data Logging Web Server (APM)
18:10 ESP32 SQLite Data Logging Web Server (APM) - Demo
22:14 ESP32 SQLite Data Logging Web Server (SM)
24:48 ESP32 SQLite Data Logging Web Server (SM) - Demo
26:10 Closing
***********************************************
Download the project files (program code files and other files) here : drive.google.com/file/d/15RMmdRwCuf1ltp9-VjUi0M4BRXqqvbk-/view?usp=sharing
The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.
***********************************************
SORRY IF MY ENGLISH IS CONFUSING, I USE AN ONLINE TRANSLATOR.
THANKS FOR WATCHING & DON'T FORGET TO LIKE , SHARE, COMMENT AND SUBSCRIBE.
***********************************************
For other video tutorials on this channel, please see this playlist:
- Basic4Android (B4A) Tutorials : youtube.com/watch?v=-BIq32-qEgA&list=PLnXsmScWzcm6RVlhPM7qg_OJ2N8OpV99d
- Electronics Tutorials : youtube.com/watch?v=rLdsWt6EP6w&list=PLnXsmScWzcm766h5Dn4AJjbJRzDfCPh4h
- Arduino Tutorials : youtube.com/watch?v=A3_EBZqCG5s&list=PLnXsmScWzcm48hvcTTRAUFcP5Fjd4u8cS
- Great Cow Basic Tutorials : youtube.com/watch?v=orHrLmEvp0o&list=PLnXsmScWzcm7xejzacm5cKJMIh_tXXxN8
- Bascom Avr Tutorials : youtube.com/watch?v=JYKSkNQq9eM&list=PLnXsmScWzcm6F9gX1wYenqjKdqVSM7d6B
- VB .NET Tutorials : youtube.com/watch?v=Sy2vjWO0ydM&list=PLnXsmScWzcm4g8AWEJ6WXVUOBh_cWF5_z
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : youtube.com/watch?v=8jMr94B8iN0&list=PLnXsmScWzcm5MERfTvcUNKsYhOUGKe3-V
- ESP32 Tutorials : youtube.com/watch?v=To3TIOFX6cA&list=PLnXsmScWzcm7Y5yCDItJP5Kny_MJ8DeDD
- ESP32 CAM Tutorials : youtube.com/watch?v=_5VmYJZI4XI&list=PLnXsmScWzcm6HjC0CIfVmRG1855tjhj5z
***********************************************
Links to download the software and libraries used and further information are available in the program code.
***********************************************
References :
- Sqlite3 Arduino library for ESP32 : github.com/siara-cc/esp32_arduino_sqlite3_lib
- SQLite3 ESP32 Web Server : github.com/FakirMaker/SQLite3-ESP32-Web-Server
- ESP32 Datalogger - Download Data File via Web Server :
randomnerdtutorials.com/esp32-datalogger-download-data-file
- JavaScript Timing Events : w3schools.com/js/js_timing.asp
- JavaScript String split : w3schools.com/jsref/jsref_split.asp
- The complete reference list can be seen in the program code file.
***********************************************
