3 ms·
For 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. Fac
by massysett 3y ago
For 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.