otty / apps
All apps/SQLite

SQLite

sqlite3

A simple command-line program that lets the user manually enter and execute SQL statements against an SQLite database.

Runs as sqlite3|macOS, Linux, Windows|sqlite.org
Open form in Otty otty.toml

Autocomplete

Fig spec, with what the manifest adds · 29 options
Published once and never changed; check the digest before caching
Download JSON
sha256
e889d6fb76465ebc9c93dbe967ad4bc29977d489e3a05052a9766156d2c59f28
Size
4189 bytes
OptionsOn sqlite3 itself
-append
Append the database to the end of the file
-ascii
Set output mode to 'ascii'
-bail
Stop after hitting an error
-batch
Force batch I/O
-column
Set output mode to 'column'
-cmd
Run "COMMAND" before reading stdin <COMMAND>
-csv
Set output mode to 'csv'
-echo
Print commands before execution
-init
Read/process named file <FILENAME>
-header
Turn headers on
-noheader
Turn headers off
-help
Show help message
-html
Set output mode to HTML
-interactive
Force interactive I/O
-line
Set output mode to 'line'
-list
Set output mode to 'list'
-lookaside
Use N entries of SZ bytes for lookaside memory <SIZE> <N>
-memtrace
Trace all memory allocations and deallocations
-mmap
Default mmap size set to N <N>
-newline
Set output row separator <SEP>
-nofollow
Refuse to open symbolic links to database files
-nullvalue
Set text string for NULL values <TEXT>
-pagecache
Use N slots of SZ bytes each for page cache memory <SIZE> <N>
-quote
Set output mode to 'quote'
-readonly
Open the database read-only
-separator
Set output column separator <SEP>
-stats
Print memory stats before each finalize
-version
Show SQLite version
-vfs
Use NAME as the default VFS <NAME>
ArgumentsPositional, in order
<FILENAME>
· filepaths