Use PostgreSQL for testing #566
Description
Currently our integration tests and server unit tests assume a sqlite3 database, while our production database is PostgreSQL. We should use PostgreSQL in testing since 1) some sql capabilities are different, and 2) Django may behave differently; Django 4.2 release notes contained some PostgreSQL-specific changes.