SQLite Suitability Debate
Discussions debate whether SQLite is sufficient for production web apps and services compared to PostgreSQL or MySQL, with many defending its performance, simplicity, and scalability for typical use cases.
Activity Over Time
Top Contributors
Keywords
Sample Comments
Underwhelming? Do you have a case for this where SQLite wouldn't be good enough?
What? SQLite is rarely the answer to replace Postgres or MySQL... it is not designed for network access nor high availability.
Ironically SQLite is excellent choice in this situation.
Don't miss out on SQLite - https://news.ycombinator.com/item?id=31159281
You're asking too many questions. Didn't you read the title? SQLite isn't enough! /s
What's the use-case for this over, say, SQLite?
Use sqlite3 until you actually cannot. It sounds like you're assuming it's bad, but it sounds ideal for your use-case since it is designed to be a fully-local database.
And SQLite is capable enough in many cases too...
Any concrete reasons? SQLite is probably good enough for 99% of websites / apps.
“SQLite doesn’t scale” is a common belief, but simply not true. It has limitations on certain sorts of loads, but you won’t run into them on this sort of app—in fact, I would expect consistently better performance from SQLite than from PostgreSQL in typical apps like this. And then SQLite is definitely easier to maintain, being just files.