> Or maybe you use sqlite in dev/tests and something bigger in prod. I had that for a while. SQLite for the test suite and Postgres for actual runs. It was a

> Or maybe you use sqlite in dev/tests and something bigger in prod. I had that for a while. SQLite for the test suite and Postgres for actual runs. It was a shitshow, having to support two separate SQL dialects with separate feature sets. Then I realized that you can actually bootstrap and start a Postgres in tmpfs in about one second, so that's what my tests do nowadays.