Mostly I think its not about cost, it is about iteration speed and ability to run in CI environments fast.
If your CI DB is not 100% in parity with the real db -- you are setting yourself up for disaster. It is a false sense of security.
Same reason I wince when people say things like "we just use SQLite in tests, but our real db is mysql/psql/etc"
The test results have no merit if they are testing against a glorified mock.
alt Hacker News
If your CI DB is not 100% in parity with the real db -- you are setting yourself up for disaster. It is a false sense of security.
Same reason I wince when people say things like "we just use SQLite in tests, but our real db is mysql/psql/etc"
The test results have no merit if they are testing against a glorified mock.