官网

https://litecli.com

下载

pip install litecli

用法

  1. # litecli --help
  3. Usage: litecli [OPTIONS] [DATABASE]
  5.   A SQLite terminal client with auto-completion and syntax highlighting.
  7.   Examples:
  8.     - litecli lite_database
  10. Options:
  11.   -V, --version           Output litecli's version.
  12.   -D, --database TEXT     Database to use.
  13.   -R, --prompt TEXT       Prompt format (Default: "\d> ").
  14.   -l, --logfile FILENAME  Log every query and its results to a file.
  15.   --liteclirc FILE        Location of liteclirc file.
  16.   --auto-vertical-output  Automatically switch to vertical output mode if the
  17.                           result is wider than the terminal width.
  19.   -t, --table             Display batch output in table format.
  20.   --csv                   Display batch output in CSV format.
  21.   --warn / --no-warn      Warn before running a destructive query.
  22.   -e, --execute TEXT      Execute command and quit.
  23.   --help                  Show this message and exit.