SQLite dashboard.
Pocket SQL ships as a single binary which may be placed wherever you please, usually a directory found in the terminal $PATH
. See the releases section of the git repository for downloads.
% pocketsql open [connection]
Connection strings are prefixed with sqlite3:
and the format is described in the go-sqlite3 driver documentation. For example, to open a SQLite database located in database.sqlite
with default pragmas, you would use the shell command:
% pocketsql open "sqlite3:file:database.sqlite"