sqlite-utils + litecli
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....