I love SQLite, but everytime I see someone claiming you do not need PostgreSQL, I feel the need to remind them that SQLite has very limited type handling and that you'll seriously miss row locking as soon as you want HA. And it's just the tip of the iceberg.
@galdor I think most people know that Postgres is much more capable when the workload gets over a certain size.
The problem is that most people also don't know where that size is.
In fact, I've used SQLite as well as Postgres and many other databases for about 30 years now, and I would struggle to answer that question outside the obvious: If you have a lot of parallel access it's time to look at Postgres.
@loke My point is that every debate on the subject is focused on performances, which is mostly irrelevant unless you have a ton of concurrent writes.
What people do not realize is how many features SQLite is missing compared to PostgreSQL. And do not get me started on the brain dead idea of allowing NULL primary keys…
Add comment