What’s Changed

• Enable support for Foreign keys
• Fix I/O errors
• Default Page size 512
• Fix for compilation errors with esp32-arduino 3.x.x by @tobozo in https://github.com/siara-cc/esp32_arduino_sqlite3_lib/pull/77
• Fix type error on comparison by @mhaberler in https://github.com/siara-cc/esp32_arduino_sqlite3_lib/pull/87

New Contributors

• @tobozo made their first contribution in https://github.com/siara-cc/esp32_arduino_sqlite3_lib/pull/77
• @mhaberler made their first contribution in https://github.com/siara-cc/esp32_arduino_sqlite3_lib/pull/87

Full Changelog: https://github.com/siara-cc/esp32_arduino_sqlite3_lib/compare/2.4...2.5

What’s Changed

• Change default page size to 512
• Bug fixes
• LITTLEFS fix and example

New Contributors

• @jojo2357 made their first contribution in https://github.com/siara-cc/esp32_arduino_sqlite3_lib/pull/57

Full Changelog: https://github.com/siara-cc/esp32_arduino_sqlite3_lib/compare/2.3...2.4

Restore configs to fix memory issues

• Upgraded Sqlite3 to 3.31.1
• Muted compiler warnings which cause errors on some compilers
• Fixed issue with unique constraint
• Removed most OMITs

No changes to features. The underlying VFS implementation connecting ESP32 to SQLite database has been changed to be based on sample VFS implementation provided by SQLite instead of adopting from NodeMCU implementation. Consequently database corruption issues are expected to be resolved. The memory footprint is also slightly reduced.

Disabled the 64k cache used for compression. This will make compression of long strings slower. Suggest use desktop for compression for long strings.

Includes Shox96 String Compression extension and examples. For more information about Shox96 visit https://github.com/siara-cc/Shox96

This release fixes compatibility issues with ESP32 Arduino core v1.0.1 released in Jan 2019.

Upgraded SQLite source to 3.25.2, removed many OMITTED options.

This is the first release for this project that is based on SQLite 20.1.