Really interesting design — especially using SQLite-compatible storage with a PostgreSQL interface.
I'm working on SNKV, which explores a different approach:
skipping the SQL layer entirely and focusing on a simple key-value interface.
It works closer to the storage layer (b-tree / WAL / pager concepts), aiming for a lightweight and minimal design, while supporting multi-process access.
Curious how you think about the tradeoff between SQL flexibility and a simpler KV interface.
https://github.com/hash-anu/snkv
