sqlite-utils is a CLI tool for manipulating SQLite databases. I’ve used sqlite-utils and shot-scraper in the past to port my blog from PostHaven to this static site.

Recently sqlite-utils added plugin support and Simon the creator of sqlite-utils wrote a few plugins to showcase the plugin system. One of them is a sqlite-utils-litecli plugin which launches an interactive shell with litecli. One obvious advantage is litecli has auto-completion and syntax highlighting which is a huge improvement over the default sqlite3 shell. Additionally this plugin allows litecli to auto-complete the custom SQL functions provided by other plugins as well.

I admire Simon’s work and I’ve learned a lot from his blogs. It is a treat to learn that he felt one of my projects (litecli) is worthy enough to spend time integrating with sqlite-utils. It is a good day!