3 ms·
Postgres is so incredibly easy to setup and has really low system requirements for simple applications and small quantities of data. SQLite has some really int
by munk-a 3y ago
Postgres is so incredibly easy to setup and has really low system requirements for simple applications and small quantities of data. SQLite has some really interesting features when it comes to portability - it's a great solution if you want to be able to trivially bundle your application and data state together and distribute it as a binary... but the barrier to running a postgres instance is incredibly low.
- massysett 3y agoFor simple applications and small quantities of data Postgres is a lot more complicated than SQLite. Just the requirement of a database server is a hurdle. Factor in that the data is stored across multiple files in some different directory, and you’ve got a lot of headache when you’re just dealing with a simple application and small amount of data.
- munk-a 3y agoThere is no requirement for a database server - until your scale requires it it's perfectly reasonable to run postgres on the localhost.
- massysett 3y agoTrue, but it’s still a separate server process, with access control and interprocess communication requirements. SQLite is just a C library so there’s no separate process to talk to.