I am getting used to with this lightrag-snkv, Now I dont need to check hacker news site again, it automatically ingest top ranked posts and I can query and check answers using natural query language.
Interesting approach — especially around modifying SQLite’s internals.
In SNKV, I’m taking almost the opposite direction:
keeping B-tree / storage-layer ideas and removing the SQL layer entirely,
to expose a minimal key-value interface.
Curious how you think about the tradeoff between simplifying the query layer vs the storage layer.
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.