Django database for swh-web has been recently migrated from sqlite3 backend to PostgreSQL one (T2945) in production.
Nevertheless, swh-web tests still use the sqlite3 backend.
We should also use the PostgreSQL backend in tests to align with production and catch possible issues prior deployment.
The pytest-django fixtures db and more advanced ones should help setting the PostgreSQL database for tests.