litecli/CHANGELOG.md

1.14.4 - 2025-01-31

Bug Fixes

• Fix the usage instructions in the \llm command.

1.14.3 - 2025-01-29

Bug Fixes

• Fix misleading "0 rows affected" status for CTEs by never displaying rows affected when the connector tells us -1
• Show an error message when \llm "question" is invoked without a database connection.

1.14.2 - 2025-01-26

Bug Fixes

• Catch errors surfaced by llm cli and surface them as runtime errors.

1.14.1 - 2025-01-25

Bug Fixes

• Capture stderr in addition to stdout when capturing output from llm cli.

1.14.0 - 2025-01-22

Features

• Add LLM feature to ask an LLM to create a SQL query.
  • This adds a new \llm special command
  • eg: \llm "Who is the largest customer based on revenue?"

Bug Fixes

• Fix the windows path shown in prompt to remove escaping.
• Fix a bug where if column name was same as table name it was crashing the autocompletion.

Internal

• Change min required python version to 3.9+

1.13.2 - 2024-11-24

Internal

• Read the version from the git tag using setuptools-scm

1.13.0 - 2024-11-23

Features

• Add \pipe_once / \| commands for sending output to a command

1.12.4 - 2024-11-11

Bug Fixes

• Fix the syntax error when \d tbl is used.

1.12.3 - 2024-09-10

Bug Fixes

• Specify build system in pyproject.toml
• Don't install tests

1.12.2 - 2024-09-07

Bug Fixes

• Fix the missing packages due to invalid pyproject.toml config

1.12.1 - 2024-09-07 (Yanked)

Internal Changes

• 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

1.11.1 - 2024-07-04

Bug Fixes

• Fix the escape sequence warning.

1.11.0 - 2024-05-03

Improvements

• When an empty \d is invoked the list of tables are returned instead of an error.
• Show SQLite version at startup.

Bug Fixes

• Support a single item in the startup commands in the config. (bug #176)

1.10.1 - 2024-3-23

Bug Fixes

• Do not crash at start up if ~/.config/litecli is not writeable. #172

1.10.0 - 2022-11-19

Features

• Adding support for startup commands being set in liteclirc and executed on startup. Limited to commands already implemented in litecli. ([#56])

Bug Fixes

• 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 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).
• Use the sqlite3 API to cancel a running query on interrupt (#164).
• Skip internal indexes in the .schema output (#170).

1.9.0 - 2022-06-06

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.

Bug Fixes

• 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.

1.8.0 - 2022-03-29

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.

1.7.0 - 2022-01-11

Features

• Add config option show_bottom_toolbar.

Bug Fixes

• Pin pygments version to prevent breaking change.

1.6.0 - 2021-03-15

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)

1.4.1 - 2020-07-27

Bug Fixes

• Fix setup.py to set long_description_content_type as markdown.

1.4.0 - 2020-07-27

Features

• Add NULLS FIRST and NULLS LAST to keywords. (Thanks: Amjith)

1.3.2 - 2020-03-11

• Fix the completion engine to work with newer sqlparse.

1.3.1 - 2020-03-11

• Remove the version pinning of sqlparse package.

1.3.0 - 2020-02-11

Features

• Added .import command for importing data from file into table. (Thanks: Zhaolong Zhu)
• Upgraded to prompt-toolkit 3.x.

1.2.0 - 2019-10-26

Features

• Enhance the describe command. (Thanks: Amjith)
• Autocomplete table names for special commands. (Thanks: Amjith)

1.1.0 - 2019-07-14

Features

• 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 and desc keywords.

Bug Fixes

• Clear error message when directory does not exist. (Thanks: Irina Truong)

1.0.0 - 2019-01-04

• To new beginnings. 🎉