litecli
litecli copied to clipboard
dbcli
CLI for SQLite Databases with auto-completion and syntax highlighting
When using `.once -o ...`, only the last line of the next output remains in the file once that command has completed. That's because the [`write_once()` function](https://github.com/dbcli/litecli/blob/c68d8027cb24b0085d5a5feeac8e2a61f668b8da/litecli/packages/special/iocommands.py#L387-L402) is [executed for...
There is an awesome `.eqp on` command in the default `sqlite3` shell. It works like this: ``` sqlite> .eqp on sqlite> select distinct book.id, (select coalesce(json_group_array(json_array(v0, v1, v2, v3, v4,...
Hi, it would be great to the option to execute a set of commands during startup. In example I often load pcre module and I would like to have it...
Hi! I just noticed a difference between litecli & sqlite default cli when running `explain ` - litecli --version Version: 1.6.0 - sqlite3 --version 3.36.0 2021-06-18 18:36:39 5c9a6c06871cb9fe42814af9c039eb6da5427a6ec28f187af7ebfb62eafa66e5 litecli: ...
REGEXP works in the shell for SQLite version 3.37.1 but not when run with litecli.
The [`sqlite3` cli](https://sqlite.org/cli.html) has additional options for the `.mode` command which enable wrapping of text within columns if it exceeds a given width. For example: .mode --wrap 40 --wordwrap This...
Note: I am both new to SQLite and litecli, so maybe I just didn't find the right documentation. I have two tables, `cards` and `card_types`. In my table `cards` I...
Thanks so much for this great tool. Would love for it to work with [spatialite databases](https://www.gaia-gis.it/fossil/libspatialite/index).
When trying to load a CSV into a table, one might have to define the CSV-Separator used. Litecli throws a Syntaxerror. in sqlite3 (working) sqlite> .mode csv sqlite> .separator ,...
The official sqlite CLI is compiled with the [fileio extension](https://sqlite.org/src/file/ext/misc/fileio.c), allowing functions like `writefile` to be used, e.g.: ```sql SELECT writefile('object0.gz', MyBlob) FROM MyTable WHERE id = 1 ``` Unfortunately,...
