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 co

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.