Wolbarg – Local-first shared memory for AI agents using SQLite

hi HN,

While building Wolbarg (an open-source shared memory SDK for AI agents), I assumed PostgreSQL would be the obvious choice for memory storage.

After benchmarking SQLite under realistic agent workloads, I was surprised by the results. For local-first and single-node deployments, SQLite handled far more than I expected while keeping the architecture much simpler.

I wrote up the benchmarks, methodology, trade-offs, and where I still think PostgreSQL is the better choice.