I've been building some sqlite plugins for playing with ngrams for text search. I'm not sure why, but I've learned a lot about the internal sqlite apis and it brings me a lot of joy. I would like to start a blog detailing some of this work but haven't found the time yet