2 ms·
I agree. SQLite is great for some simple purposes, but this article acts like launching PostgreSQL is impossibly difficult and can only be done on a server 100m
by Aurornis 3y ago
I agree. SQLite is great for some simple purposes, but this article acts like launching PostgreSQL is impossibly difficult and can only be done on a server 100ms away from your web server.
For simple apps I just run Postgres on the same server and size things appropriately in settings. It’s really not hard and it’s well-trodden territory.
If someone is making a single-tenant app that runs on an embedded device or something then SQLite is awesome.
The way this developer concludes that “most of you reading this” should use SQLite is very strange. Is that indicative of his audience building small or toy websites rather than actual production websites?
- BenjiWiebe 3y agoHow many actual production websites are actually too much for SQLite? 1%? Most production websites are not multi million dollar businesses.
- Ensorceled 3y agoMost production websites are running Wordpress or something like Squarespace ...
- d1sxeyes 3y agoExactly the point here. There’s a bunch of brilliant reasons to use SQLite. One good reason is that by the time you outgrow it, you’re probably shifting enough data for it to be a worthwhile use of an engineering team’s time to plan a migration. If you use an ORM from the beginning, you might not even have to change very much of your application code.