Comment by jwilliams

I use pglite for unit/integration tests and it's been fantastic.

Note that it uses "single user mode." This means a single connection at a time, and thus no concurrent transactions. That takes you a little bit closer to SQLite's single-writer.