When running tests locally, the tests interact with your normal development database. Since tests may arbitrarily add and remove data, it would be nice if they ran in a separate environment. Additionally, if we could completely mock our database for tests it could speed them up since we would not have to send queries to PostgreSQL.
Solution
Investigate whether Prisma supports using SQLite/in-memory database for testing without adding too much complexity (maybe start here?).
Investigate whether test containers would be a good fit for us,
Description
When running tests locally, the tests interact with your normal development database. Since tests may arbitrarily add and remove data, it would be nice if they ran in a separate environment. Additionally, if we could completely mock our database for tests it could speed them up since we would not have to send queries to PostgreSQL.
Solution