4 ms·
why sqlite over postgres?
by oliver236 6mo ago
why sqlite over postgres?
- Croak 6mo agoYou remove a bit of complexity. Sure Postgres is not hard to set up sn to connect to, but Sqlite is just opening a file. It being a file makes it also very easy to test or debug you application.
- koliber 6mo agopostgres is great and is also a good default choice. It needs a bit more setup than sqlite. Unless I need a capability that postgres provides, I go with sqlite. It just works.
- Hendrikto 6mo agoIt is simpler and removes failure points. You don’t need a separate database server process or network/socket connections. Everything happens in-process.
- RugnirViking 6mo agohave you ever run automated tests on postgres? how long did they take?