Right now the test infrastructure uses an SQLite database. While it's easy to set up, we should instead use a containerized PSQL database, so it matches the actual environment.

AC:

• Local tests use a containerized PSQL database
• Github actions for testing also use a PSQL database