pgserver

Try pgserver https://github.com/orm011/pgserver It uses real Postgres rather than WASM

For unit testing, I still use TestContainers which spins a full Postgres in Docker. But new alternatives like this make py-pglite (https://github.com/wey-gu/py-pglite) possible which is Python unit testing with PGlite. Even so, for Python unit testing I'm more confident in something like pgserver (https://github.com/orm011/pgserver) which offers the full, real Postgres in a lightweight pip package. Note: my take is specifically for unit testing, not other use cases!

Not directly an answer, but similar what if thinking got me wondering: wouldn't it be cool to be able to use postgres much like how you use sqlite with python? I implemented this idea as a pip-installable python package, https://github.com/orm011/pgserver, and your feedback would be great :) I use it for my projects.

Hi, the main motivation of this small personal project is the ability to build Postgres-backed python apps that remain fully pip-installable despite the dependency, while saving your users any need to setup Postgres if they don't have it. It also helps me, as a developer, to not have to remember how to set up postgres, which I find is one main barrier to using it for small stuff. It's a little project of mine that may be helpful to more people. I'm curious to hear your feedback (ps. I know about SQLite, but sometimes you want/need to build against postgres)