6 ms·
Try CREATE TABLE UNLOGGED with postgres. The diversity of RDBMS and SQL dialects defeats the point of integration testing the persistence layer with SQLite.
by bradmwalker 10y ago
Try CREATE TABLE UNLOGGED with postgres. The diversity of RDBMS and SQL dialects defeats the point of integration testing the persistence layer with SQLite.
- snovv_crash 10y agoYes, but a large portion of code that needs testing is simple inserting, queries and joins, and SQLite can do this without any problems. You can push complex or db-specific work to slower test groups, but not everything requires it.
- abiox 10y agoeven this is less clear - for some dbs it's normal to use a sequence for rowid's (vs some sort of autoincrement) and i don't think sqlite offers all the same behavior there.