In-process reimplementation of PostgreSQL backed by SQLite-compatible storage
github.comFrom the Turso CEO
> What if we could run Postgres as a single file, and take advantage of the best SQLite has to offer?
Today I am announcing pg-micro, a crazy experiment I've been undertaking to make this happen.
pg-micro is different from other approaches because it is fully local, and expected to be fast: there is no concurrency limitation and no statement translation.
[...]
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.
Seems kind of crazy, but I like it