Stephen has a whole series of blog posts on SQLite (in Rails) that I highly recommend. I've learned most of what I know about SQLite from him!
https://fractaledmind.github.io/2024/04/15/sqlite-on-rails-t...
Also, hello Lee! I miss being in a Slack with you!
Discord is the new slack ;)
https://kerkour.com/sqlite-for-servers
Previous (brief) HN discussion on that post:
https://news.ycombinator.com/item?id=39383725
And, if this piques your interest, there was recently discussion on distributed SQLite from the same author:
https://news.ycombinator.com/item?id=39975596