3 ms·
SQLite has become my new go-to when starting any project that needs a DB. The performance is very fast, and if anything is ever successful enough to outgrow SQL
by pseudosavant 6mo ago
SQLite has become my new go-to when starting any project that needs a DB. The performance is very fast, and if anything is ever successful enough to outgrow SQLite, it wouldn't be that hard to switch it out for Postgres. Not having to maintain/backup/manage a separate database server is cheaper and easier.
- koliber 6mo agoBackups are super-simple as well. I'm also a convert.
- oliver236 6mo agowhy 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?
- direwolf20 6mo agoIf it's a server app, I almost always have to switch to Postgres eventually so now I start with Postgres.