All Versions
54
Latest Version
Avg Release Cycle
60 days
Latest Release
1031 days ago

Changelog History
Page 5

  • v0.18.0 Changes

    πŸ”‹ Features:

    • βž• Add fuzzy matching for the table names and column names.

    Matching very long table/column names are now easier with fuzzy matching. The fuzzy match works like the fuzzy open in SublimeText or Vim's Ctrl-P plugin.

    eg: Typing djmv will match django_migration_views since it is able to match parts of the input to the full table name.

    • πŸ”„ Change the timing information to seconds.

    The Command Time and Format Time are now displayed in seconds instead of a unitless number displayed in scientific notation.

    • πŸ‘Œ Support for named queries (favorite queries). (Thanks: Brett Atoms_)

    Frequently typed queries can now be saved and recalled using a name using newly added special commands (\n[+], \ns, \nd).

    eg:

    ::

    # Save a query
pgcli> \ns simple select * from foo
saved

# List all saved queries
pgcli> \n+

# Execute a saved query
pgcli> \n simple

# Delete a saved query
pgcli> \nd simple

    • Pasting queries into the pgcli repl is orders of magnitude faster. (Thanks: Jonathan Slenders_)

    • βž• Add support for PGPASSWORD environment variable to pass the password for the postgres database. (Thanks: Irina Truong_)

    • βž• Add the ability to manually refresh autocompletions by typing \# or \refresh. This is useful if the database was updated by an external means and you'd like to refresh the auto-completions to pick up the new change.

    πŸ› Bug Fixes:

    • Fix an error when running \d table_name when running on a table with rules. (Thanks: Ali KargΔ±n_)
    • Fix a pgcli crash when entering non-ascii characters in Windows. (Thanks: Darik Gamble, Jonathan Slenders)
    • πŸ›  Faster rendering of expanded mode output by making the horizontal separator a fixed length string.
    • 0️⃣ Completion suggestions for the \c command are not auto-escaped by default.

    Internal Changes:

    • πŸ”¨ Complete refactor of handling the back-slash commands.
    • Upgrade prompt_toolkit to 0.42. (Thanks: Jonathan Slenders_)
    • πŸ”„ Change the config file management to use ConfigObj.(Thanks: Brett Atoms_)
    • βž• Add integration tests using behave. (Thanks: Irina Truong_)

  • v0.17.0 Changes

    πŸ”‹ Features:

    • βž• Add support for auto-completing view names. (Thanks: Darik Gamble_)
    • βž• Add support for building RPM and DEB packages. (Thanks: dp_)
    • βž• Add subsequence matching for completion. (Thanks: Daniel Rocco_) Previously completions only matched a table name if it started with the partially typed word. Now completions will match even if the partially typed word is in the middle of a suggestion. eg: When you type 'mig', 'django_migrations' will be suggested.
    • Completion for built-in tables and temporary tables are suggested after entering a prefix of pg_. (Thanks: Darik Gamble_)
    • βž• Add place holder doc strings for special commands that are planned for implementation. (Thanks: Irina Truong_)
    • Updated version of prompt_toolkit, now matching braces are highlighted. (Thanks: Jonathan Slenders_)
    • βž• Added support of \\e command. Queries can be edited in an external editor. (Thanks: Irina Truong_) eg: When you type SELECT * FROM \e it will be opened in an external editor.
    • βž• Add special command \dT to show datatypes. (Thanks: Darik Gamble_)
    • βž• Add auto-completion support for datatypes in CREATE, SELECT etc. (Thanks: Darik Gamble_)
    • πŸ‘Œ Improve the auto-completion in WHERE clause with logical operators. (Thanks: Darik Gamble_) *

    πŸ› Bug Fixes:

    • πŸ›  Fix the table formatting while printing multi-byte characters (Chinese, Japanese etc). (Thanks: θ”‘δ½³η”·_)
    • Fix a crash when pg_catalog was present in search path. (Thanks: Darik Gamble_)
    • ⚑️ Fixed a bug that broke \\e when prompt_tookit was updated. (Thanks: FranΓ§ois Pietka_)
    • πŸ›  Fix the display of triggers as shown in the \d output. (Thanks: Dimitar Roustchev_)
    • πŸ›  Fix broken auto-completion for INNER JOIN, LEFT JOIN etc. (Thanks: Darik Gamble_)
    • πŸ›  Fix incorrect super() calls in pgbuffer, pgtoolbar and pgcompleter. No change in functionality but protects against future problems. (Thanks: Daniel Rocco_)
    • βž• Add missing schema completion for CREATE and DROP statements. (Thanks: Darik Gamble_)
    • πŸ›  Minor fixes around cursor cleanup.

  • v0.16.3 Changes

    πŸ› Bug Fixes:

    • βž• Add more SQL keywords for auto-complete suggestion.
    • Messages raised as part of stored procedures are no longer ignored.
    • πŸ‘‰ Use postgres flavored syntax highlighting instead of generic ANSI SQL.

  • v0.16.2 Changes

    πŸ› Bug Fixes:

    • πŸ›  Fix a bug where the schema qualifier was ignored by the auto-completion. As a result the suggestions for tables vs functions are cleaner. (Thanks: Darik Gamble_)
    • βœ‚ Remove scientific notation when formatting large numbers. (Thanks: Daniel Rocco_)
    • βž• Add the FUNCTION keyword to auto-completion.
    • Display NULL values as instead of empty strings.
    • πŸ›  Fix the completion refresh when \connect is executed.

  • v0.16.1 Changes

    πŸ› Bug Fixes:

    • πŸ›  Fix unicode issues with hstore.
    • πŸ›  Fix a silent error when database is changed using \c.

  • v0.16.0 Changes

    πŸ”‹ Features:

    • βž• Add \ds special command to show sequences.
    • βž• Add Vi mode for keybindings. This can be enabled by adding 'vi = True' in ~/.pgclirc. (Thanks: Jay Zeng_)
    • βž• Add a -v/--version flag to pgcli.
    • βž• Add completion for TEMPLATE keyword and smart-completion for 'CREATE DATABASE blah WITH TEMPLATE '. (Thanks: Daniel Rocco_)
    • βž• Add custom decoders to json/jsonb to emulate the behavior of psql. This removes the unicode prefix (eg: u'Γ‰owyn') in the output. (Thanks: Daniel Rocco_)
    • βž• Add \df special command to show functions. (Thanks: Darik Gamble_)
    • πŸ‘‰ Make suggestions for special commands smarter. eg: \dn - only suggests schemas. (Thanks: Darik Gamble_)
    • πŸ–¨ Print out the version and other meta info about pgcli at startup.

    πŸ› Bug Fixes:

    • πŸ›  Fix a rare crash caused by adding new schemas to a database. (Thanks: Darik Gamble_)
    • πŸ‘‰ Make \dt command honor the explicit schema specified in the arg. (Thanks: Darik Gamble_)
    • πŸ–¨ Print BIGSERIAL type as Integer instead of Float.
    • πŸ‘‰ Show completions for special commands at the beginning of a statement. (Thanks: Daniel Rocco_)
    • πŸ‘ Allow special commands to work in a multi-statement case where multiple sql statements are separated by semi-colon in the same line.

  • v0.15.4 Changes

    • Dummy version to replace accidental PyPI entry deletion.

  • v0.15.3 Changes

    • Override the LESS options completely instead of appending to it.

  • v0.15.2 Changes

    • βͺ Revert back to using psycopg2 as the postgres adapter. psycopg2cffi fails for some tests in Python 3.

  • v0.15.0 Changes

    πŸ”‹ Features:

    • βž• Add syntax color styles to config.
    • βž• Add auto-completion for COPY statements.
    • πŸ”„ Change Postgres adapter to psycopg2cffi, to make it PyPy compatible. Now pgcli can be run by PyPy.

    πŸ› Bug Fixes:

    • Treat boolean values as strings instead of ints.
    • πŸ‘‰ Make \di, \dv and \dt to be schema aware. (Thanks: Darik Gamble_)
    • πŸ‘‰ Make column name display unicode compatible.