- Add
\pipe_once
/\|
commands for sending output to a command
- Fix the syntax error when
\d tbl
is used.
- Specify build system in
pyproject.toml
- Don't install tests
- Fix the missing packages due to invalid pyproject.toml config
- Modernize the project with following changes:
- pyproject.toml instead of setup.py
- Use ruff for linting and formatting
- Update GH actions to use uv and tox
- Use GH actions to release a new version
- Fix the escape sequence warning.
- When an empty
\d
is invoked the list of tables are returned instead of an error. - Show SQLite version at startup.
- Support a single item in the startup commands in the config. (bug #176)
- Do not crash at start up if ~/.config/litecli is not writeable. #172
- Adding support for startup commands being set in liteclirc and executed on startup. Limited to commands already implemented in litecli. ([#56])
- Fix [#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 getsuccessful = False
inquery_history
. - Changed
master
tomain
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). - Use the sqlite3 API to cancel a running query on interrupt (#164).
- Skip internal indexes in the .schema output (#170).
- 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.
- Fix #120. Make the
.read
command actually read and execute the commands from a file. - Fix #96 the crash in VI mode when pressing
r
.
- Update compatible Python versions. (Thanks: [blazewicz])
- Add support for Python 3.10. (Thanks: [blazewicz])
- Drop support for Python 3.6. (Thanks: [blazewicz])
- Upgrade cli_helpers to workaround Pygments regression.
- Use get_terminal_size from shutil instead of click.
- Add config option show_bottom_toolbar.
- Pin pygments version to prevent breaking change.
- 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])
- Fix compatibility with sqlparse >= 0.4.0. (Thanks: chocolateboy)
- Fix invalid utf-8 exception. (Thanks: Amjith)
- Fix setup.py to set
long_description_content_type
as markdown.
- Add NULLS FIRST and NULLS LAST to keywords. (Thanks: Amjith)
- Fix the completion engine to work with newer sqlparse.
- Remove the version pinning of sqlparse package.
- Added
.import
command for importing data from file into table. (Thanks: Zhaolong Zhu) - Upgraded to prompt-toolkit 3.x.
- Enhance the
describe
command. (Thanks: Amjith) - Autocomplete table names for special commands. (Thanks: Amjith)
- Added
.read
command for reading scripts. - Added
.load
command for loading extension libraries. (Thanks: Zhiming Wang) - Add support for using
?
as a placeholder in the favorite queries. (Thanks: Amjith) - Added shift-tab to select the previous entry in the completion menu. Amjith
- Added
describe
anddesc
keywords.
- Clear error message when directory does not exist. (Thanks: Irina Truong)
- To new beginnings. 🎉