I've been writing serverside SQLite applications for several years now and I still picked things up from this article, which is extremely good. https://kerkour.com/sqlite-for-servers
Optimizing SQLite for servers

SQLite is often misconceived as a "toy database", only good for mobile applications and embedded systems because it's default configuration is optimized for embedded use cases, so most people trying it will encounter poor performances and the dreaded SQLITE_BUSY error. But what if I told you that by tuning a

Sylvain Kerkour
@tqbf I learned a lot from that post too. Adding LiteFS on top seems to change a lot of the performance characteristics though. I want Ben Johnson to write a similar post for sqlite+LiteFS.
@bento Yeah I got the post from your code. :)