gittech. site

for different kinds of informations and explorations.

Pocket SQL

Published at
Dec 31, 2024

Pocket SQL

SQLite dashboard.

Record detail view in Pocket SQL

Install

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.

Usage

% 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"