|
|
|
|
|
|
by majewsky
2588 days ago
|
|
|
> sqlite had been valuable for a long time as it made testing/local dev fast FWIW, in my current project, I've deviated from my usual pattern of using SQLite for testing and Postgres for production and went all-in with Postgres in order to use some Postgres features that SQLite does not have (enum types, row-level locking). I have a very small shell script [1] for starting an isolated Postgres instance during test suite runs, and that works fine for me. The speed difference is about 100-200 ms per test suite run for the `pg_ctl start` and `pg_ctl stop`. [1] https://github.com/sapcc/castellum/blob/master/testing/with-... |
|
|