All Versions
54
Latest Version
Avg Release Cycle
60 days
Latest Release
1364 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.