4 ms·

Backups are super-simple as well. I'm also a convert.

• oliver236 6mo ago
  why sqlite over postgres?
  • Croak 6mo ago
    You 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 ago
    postgres 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 ago
    It 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 ago
    have you ever run automated tests on postgres? how long did they take?