Litecli

Bug Fixes

* Do not crash at start up if ~/.config/litecli is not writeable. [172](https://github.com/dbcli/litecli/issues/172)

Features

* Adding support for startup commands being set in liteclirc and executed on startup. Limited to commands already implemented in litecli. ([[56](https://github.com/dbcli/litecli/issues/56)])

Bug Fixes

* Fix [[146](https://github.com/dbcli/litecli/issues/146)], making sure `.once`
can be used more than once in a session.
* Fixed setting `successful = True` only when query is executed without exceptions so
failing queries get `successful = False` in `query_history`.
* Changed `master` to `main` in CONTRIBUTING.md to reflect GitHubs new default branch
naming.
* Fixed `.once -o <file>` by opening the output file once per statement instead
of for every line of output ([148](https://github.com/dbcli/litecli/issues/148)).
* Use the sqlite3 API to cancel a running query on interrupt
([164](https://github.com/dbcli/litecli/issues/164)).
* Skip internal indexes in the .schema output
([170](https://github.com/dbcli/litecli/issues/170)).

Features

* Add support for ANSI escape sequences for coloring the prompt.
* Add support for `.indexes` command.
* Add an option to turn off the auto-completion menu. Completion menu can be
triggered by pressed the `<tab>` key when this option is set to False. Fixes
[105](https://github.com/dbcli/litecli/issues/105).

Bug Fixes

* Fix [120](https://github.com/dbcli/litecli/issues/120). Make the `.read` command actually read and execute the commands from a file.
* Fix [96](https://github.com/dbcli/litecli/issues/96) the crash in VI mode when pressing `r`.

Features

* Update compatible Python versions. (Thanks: [blazewicz])
* Add support for Python 3.10. (Thanks: [blazewicz])
* Drop support for Python 3.6. (Thanks: [blazewicz])

Bug Fixes

* Upgrade cli_helpers to workaround Pygments regression.
* Use get_terminal_size from shutil instead of click.

Features

* Add config option show_bottom_toolbar.

Bug Fixes

* Pin pygments version to prevent breaking change.

Features

* Add verbose feature to `favorite_query` command. (Thanks: [Zhaolong Zhu])
* `\f query` does not show the full SQL.
* `\f+ query` shows the full SQL.
* Add prompt format of file's basename. (Thanks: [elig0n])

Bug Fixes

* Fix compatibility with sqlparse >= 0.4.0. (Thanks: [chocolateboy])
* Fix invalid utf-8 exception. (Thanks: [Amjith])