Despite several years of looking for a much more optimal solution than SQLite for very “simply” local or embedded storage (for SlimIO in particular) well, I can tell you that I haven't found a better one yet.
SQLite is really a solid and mature project that works very well. For SlimIO I made the effort to read all of the official documentation and it was a huge surprise for me… So many things I didn't know about the operation and the possible optimizations (like what.. always read the doc !).
Drivers available in the ecosystem:
- sqlite3
- better-sqlite3 (completely synchronous).
- 🆕 esqlite (very recent driver by mscdex).
Articles: