@ademan @alex postgresql's process/server based arch just sucks for massively KV things, LMDB/RocksDB are definitely better

looking over the code, there's a sqlite DB per thread so there's never a lock, and queries either go over all of them, or query the right shard/thread

very elegant, uber performant