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?
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.