edge-sql VS esp32_arduino_sqlite3_lib

edge-sql [1] allows arbitrary SQLite queries to be executed over an immutable external data set. The demo uses a Forex data set stored in Workers KV.

Client issued arbitrary queries is one of the use cases for GraphQL and publishing immutable data sets on the web is the main use case for Simon Wilson’s Datasette [2].

In-memory SQLite compiled to WASM works in the browser and Node.js too. In the future, we can expect proper ACID operations on any WASM runtime that supports fsync in WASI [3], a POSIX-like API.

[1] https://github.com/lspgn/edge-sql

[2] https://datasette.io/

[3] https://wasi.dev/

Then your debugging is mostly around writing thing that generates that flat file and then also around whatever functions read and index the flat file. There is a pretty decent sqlite3 library for Arduino on ESP32 at least: https://github.com/siara-cc/esp32_arduino_sqlite3_lib (and actually another one for idf: https://github.com/siara-cc/esp32-idf-sqlite3 )

there's sqlite for esp32 if the dataset is static and the sqlite file can fit on a SPIFFS partition

Interesting idea, I guess there's a use case for something with a lighter memory footprint than sqlite3 on an embedded platform.