Hacker News new | ask | show | jobs
by felipeccastro 1082 days ago
Doesn't the WAL mode solve the high concurrency write situation? If it can't be relied on busy season, why the push for Sqlite in production?
2 comments
benbjohnson 1082 days ago
WAL solves the high concurrency read situation. Not the writes. SQLite can do thousands of writes per second in WAL mode which is more than enough for the vast majority of applications out there. It's not like most businesses could fulfill thousands of orders per second even if their database could write them.
link
tmpz22 1082 days ago
> If it can't be relied on busy season, why the push for Sqlite in production?

I think its less about proving sqlite is awesome for everything then it is about proving it can be awesome and practical for some projects.

link