> I've found that replacing the database with in memory SQLite for tests is a sweet spot

Does that cover the first two examples brought up by the article? Constraint violations and default value handling.