https://blog.alcazarsec.com/tech/posts/sqlite-in-production
Alcazar
SQLite in production for as long as you can get away with it
WAL, a handful of pragmas, local disk, short writes, and continuous backups to object storage. When that stops being enough, you will feel it in contention before you feel it in hype.
