This small PR adds support for litecli as the default when dropping into a sqlite shell via make shell.
litecli is part of a greater collection of command line database clients with "modern" enhancements like syntax highlighting, autocompletion, saved queries, etc. You can read more about them here: https://www.dbcli.com/
Motivation
Remembering the particular vernacular of column names can prove challenging. Making the experience friendly and truly interactive for students allows them to focus more on writing the queries.
Changes
The shell target checks if litecli is installed according to output from which - if it is installed, it will be used instead of sqlite3.
The setup target includes the necessary code to install it via pip.
As per make documentation for conditionals, the ifeq, else, and endif directives should not be tabbed in
to prevent them from being interpreted as shell commands.
Hi Russ,
This small PR adds support for
liteclias the default when dropping into a sqlite shell viamake shell.litecliis part of a greater collection of command line database clients with "modern" enhancements like syntax highlighting, autocompletion, saved queries, etc. You can read more about them here: https://www.dbcli.com/Motivation
Remembering the particular vernacular of column names can prove challenging. Making the experience friendly and truly interactive for students allows them to focus more on writing the queries.
Changes
shelltarget checks iflitecliis installed according to output fromwhich- if it is installed, it will be used instead of sqlite3.setuptarget includes the necessary code to install it via pip.As per make documentation for conditionals, the
ifeq,else, andendifdirectives should not be tabbed in to prevent them from being interpreted as shell commands.