|LiteCLI - SQLite Client with Autocomplete
|Written by Nikos Vaggalis
|Tuesday, 22 January 2019
LiteCLI is a new open source command line client with many good features. Built in Python it is hosted on GitHub.
There are quite a few SQLite GUI clients, such as DB Browser and Sqliteman, but not that many command line/terminal ones.
It all makes for a really smooth experience.
Installing it is just as easy. This is the way I'd suggest if you're on Windows:
Open a powershell session as admin and run:
For a better terminal experience than the default cmd.exe, install Hyper which is based on Electron:
Open hyper and run:
To take it for a test run, let's copy the places.sqlite database, where Firefox keeps the user's bookmarks, history etc to a test folder and run:
Now inside the client, we can check the schema and work with the tables, say "moz_places", which can even be chosen from the list of the auto suggestions:
However, because the output of the row exceeds the width of the terminal, it doesn't look that good:
Auto-suggestion aside, there's also Auto-completion:
And if there's a query that you frequently run, you can even save it as favorite and re-run it by just calling it by its nickname:
Another advantage of LiteCLI is that it's also fully customizable. For example you can change the syntax_style of the key bindings:
the table format output as seen when running SQL queries:
and much more.
I had been on the lookout for a good cli alternative like this for quickly running queries on databases stored inside Android emulators.
It would had certainly come handy at the time I was doing my Android developer Nanodegree Capstone project. I could have accessed my custom SQLite database simply as:
Better late than never!
or email your comment to: firstname.lastname@example.org
|Last Updated ( Tuesday, 22 January 2019 )