I've been using Jekyll for my blog for nearly 10 years now. I also recently wrote a little plugin that uses SQLite, though I'm using it in a minimal way as a vector database rather than storing content in it right now.

https://www.mikekasberg.com/blog/2024/04/23/better-related-p...