I would make an exception for SQLite. Here's how you do it: - Write your schema so it's compatible with SQLite and your production DB, such as PostgreSQL. - W

I would make an exception for SQLite. Here's how you do it: - Write your schema so it's compatible with SQLite and your production DB, such as PostgreSQL. - When you're running tests, use SQLite instead of Postgres to run those tests. - Use SQLite in production. Go ahead, do it. You don't need Postgres, SQLite is fine. I promise. Trust me