ARDUINO IDE + ESP32 + SQLite (SQLite3) Database | ESP32 SQLite (Getting Started and Data Logging)

*********************************************** Follow and contact me on Instagram : https://www.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 : https://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 : https://www.youtube.com/watch?v=-BIq32-qEgA&list=PLnXsmScWzcm6RVlhPM7qg_OJ2N8OpV99d - Electronics Tutorials : https://www.youtube.com/watch?v=rLdsWt6EP6w&list=PLnXsmScWzcm766h5Dn4AJjbJRzDfCPh4h - Arduino Tutorials : https://www.youtube.com/watch?v=A3_EBZqCG5s&list=PLnXsmScWzcm48hvcTTRAUFcP5Fjd4u8cS - Great Cow Basic Tutorials : https://www.youtube.com/watch?v=orHrLmEvp0o&list=PLnXsmScWzcm7xejzacm5cKJMIh_tXXxN8 - Bascom Avr Tutorials : https://www.youtube.com/watch?v=JYKSkNQq9eM&list=PLnXsmScWzcm6F9gX1wYenqjKdqVSM7d6B - VB .NET Tutorials : https://www.youtube.com/watch?v=Sy2vjWO0ydM&list=PLnXsmScWzcm4g8AWEJ6WXVUOBh_cWF5_z - LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : https://www.youtube.com/watch?v=8jMr94B8iN0&list=PLnXsmScWzcm5MERfTvcUNKsYhOUGKe3-V - ESP32 Tutorials : https://www.youtube.com/watch?v=To3TIOFX6cA&list=PLnXsmScWzcm7Y5yCDItJP5Kny_MJ8DeDD - ESP32 CAM Tutorials : https://www.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 : https://github.com/siara-cc/esp32_arduino_sqlite3_lib - SQLite3 ESP32 Web Server : https://github.com/FakirMaker/SQLite3-ESP32-Web-Server - ESP32 Datalogger - Download Data File via Web Server : https://randomnerdtutorials.com/esp32-datalogger-download-data-file/ - JavaScript Timing Events : https://www.w3schools.com/js/js_timing.asp - JavaScript String split : https://www.w3schools.com/jsref/jsref_split.asp - The complete reference list can be seen in the program code file. ***********************************************