SQLite is great, but I would not use it in a multi-machine, multi-processing environment.
Developers do need to understand that it's SQLite, not a poor man's Postgres. This require correct engineering, and the SQLite docs are in a class of their own in patiently explaining in simple terms how to do this.
If you embrace what SQLite is, you can do a remarkable number of things with it, safely and reliably.
> SQLite docs are in a class of their own in patiently explaining in simple terms how to do this.
Yes! I love reading the SQLite (and Fossil!) docs. They're so beautifully written!
Yeah great, you shouldn't. SQLite is meant to be replacement of custom files to store data by apps (mobile apps, desktop apps, server apps). This isn't meant to scale to millions of users, but just store data in a structured manner.