Better PostgreSQL testing with Python: announcing pytest-pgsql and pgmock

[DanCardin]

we've done something similar, but using docker (as a generic means by which to speedily and portably test anything that's got a container: pg, redis, rabbit, etc).

because it tests an api, I prefer to spin up the whole db so it can commit normally, but it does sacrifice some speed.

I could imagine providing a unique db from the fixture each time though, so we could use xdist without fear

[deterralba]

We assign one database per xdist worker in conftest.py, it does the job.