Create / access SQLite3 database files using this library through SPIFFS / SD Cards.
For more information, please see https://github.com/siara-cc/esp32_arduino_sqlite3_lib
Install ESP-IDF sdk using instructions from https://docs.espressif.com/projects/esp-idf/en/latest/get-started/.
Unzip this project under esp-idf/components folder. Or if you are cloning the repository at https://github.com/espressif/esp-idf, add this repository as submodule using:
git submodule add https://github.com/siara-cc/esp32-idf-sqlite3 components/esp32-idf-sqlite3
.
cd esp-idf-v4.1.1
, install using sudo ./install.sh
git submodule add https://github.com/siara-cc/esp32-idf-sqlite3 components/esp32-idf-sqlite3
git submodule add https://github.com/siara-cc/esp32-idf-sqlite3-examples examples/esp32-idf-sqlite3-examples
cd examples/esp32-idf-sqlite3-examples/spiffs
make flash
miniterm.py <device> 115200
and reset boardTo check out how this library works, please try the examples using:
git submodule add https://github.com/siara-cc/esp32-idf-sqlite3-examples examples/esp32-idf-sqlite3-examples
For instance, to check how Sqlite3 databases can be created on SPIFFS, navigate to the folder examples/esp32-idf-sqlite3-examples/spiffs
and invoke make flash
.
Many configurations specific to SQLite library have been set in the sdkconfig.defaults
file, such as:
The Flash size has been assumed as 4MB for SPIFFS example. Please change any of these configurations if necessary.
If you face any issues, please contact the author (Arundale Ramanathan) at arun@siara.cc or create a github issue.