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>