Comment by aranke

Curious if you prototyped DuckDB before deciding to invest further into SQLite.

DuckDB works great as an in-memory database (it's also the default mode).