[jddj]

There are absolutely production web apps running sqlite as the datastore.

The "one writer at a time and the rest queue" caveat is fine for most web applications when writes happen in single digit / low 10s of ms

[BaculumMeumEst]

Is there documentation on how to configure SQLite in the manner you’re describing?

[jddj]

From the performance angle, there's one quoted down thread at https://news.ycombinator.com/item?id=40656043

From the webapp angle check out, for example, pocketbase.io which is an open source Go supabase style backend which wraps sqlite. They have benchmarks etc available.