SQLite-GUI

NAME

SYNOPSIS

SQLite-GUI [ options ]

SQLite-GUI D:/databases/bookstore.sqlite

SQLite-GUI D:/databases/bookstore.sqlite import-csv "D:/data/my file.csv" my_table > import-result.txt

SQLite-GUI D:/databases/bookstore.sqlite export-csv D:/export/books.csv "select * from books" > export-result.txt

AVAILABILITY

DESCRIPTION

Small, simple, powerful, fast, free.

For more information about SQLite-GUI see: https://github.com/little-brother/sqlite-gui/wiki

For SQL syntax understood by SQLite, see: https://sqlite.org/lang.html

Key Features:

-

Syntax highlighting and code completion

-

Edit multiple tables at the same time

-

Colorized data grid

-

Store an execution history and user scripts

-

Export/Import data

-

Database diagram

-

Database comparison

-

Search text in the whole database

-

Quick data references

-

Terminal mode

-

Charts

-

Query parameters

-

Query shortcuts

-

Custom functions

-

Jinja scripting (experimental)

-

Data generator

-

Extension pack

-

Built-in REST API web server

-

Demo database "Bookstore" for beginners

OPTIONS

-h

usage message.

-i

install the SQLite-GUI command to the 'SendTo' context menu in 'Windows Explorer'.

-u

uninstall the SQLite-GUI command from the 'SendTo' context menu in 'Windows Explorer'.

-V

print program version.

options

additional options.

See also: https://github.com/little-brother/sqlite-gui/wiki#command-line-arguments

ENVIRONMENT

EXIT STATUS

0

no error.

4

usage message displayed.

5

version message displayed.

FILES

etc/SQLite-GUI.cfg

configuration file copy of the active prefs.sqlite file of SQLite-GUI.

var/db/sqlite/

directory for SQLite databases.

EXAMPLES

SEE ALSO

NOTES

BUGS

AUTHOR

COPYRIGHT

This is free software; see WA2LWinTools/man/COPYING for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.