tests should be runnable directly through pytest

[bhearsum]

At the very least, this is not possible at the moment because they require a postgres db running. Other projects we use in-memory sqlite databases to workaround this, which is probably worth trying here.

[jcristau]

https://pypi.org/project/pytest-postgresql might be an option if we want to keep testing with pg.