Describe the new feature you would like to see
The tests are currently running towards an in-memory SQLite database. From our experience this does not capture all issues which might arise in the Postgres database used in our environments.
Describe the solution you'd like
Investigate a solution where the tests may be run towards a proper postgres database. A tradeoff must be made in efficiency and speed. Testcontainers will be evaluated to see if it is suitable. We would like to have a solution for integration tests no matter what.
How will this feature affect the current Threat Model?
Improved due to better test coverage and quality.
Describe the new feature you would like to see The tests are currently running towards an in-memory SQLite database. From our experience this does not capture all issues which might arise in the Postgres database used in our environments.
Describe the solution you'd like Investigate a solution where the tests may be run towards a proper postgres database. A tradeoff must be made in efficiency and speed. Testcontainers will be evaluated to see if it is suitable. We would like to have a solution for integration tests no matter what.
How will this feature affect the current Threat Model? Improved due to better test coverage and quality.