All Versions
49
Latest Version
Avg Release Cycle
60 days
Latest Release
-

Changelog History
Page 3

  • v1.7.0 Changes

    • βͺ Refresh completions after COMMIT or ROLLBACK. (Thanks: Irina Truong_)
    • πŸ›  Fixed DSN aliases not being read from custom pgclirc (issue #717). (Thanks: Irina Truong_).
    • 🍎 Use dbcli's Homebrew tap for installing pgcli on macOS (issue #718) (Thanks: Thomas Roten_).
    • Only set LESS environment variable if it's unset. (Thanks: Irina Truong_)
    • Quote schema in SET SCHEMA statement (issue #469) (Thanks: Irina Truong_)
    • Include arguments in function suggestions (Thanks: Joakim Koljonen_)
    • πŸ–¨ Use CLI Helpers for pretty printing query results (Thanks: Thomas Roten_).
    • Skip serial columns when expanding * for INSERT INTO foo(* (Thanks: Joakim Koljonen_).
    • πŸ’» Command line option to list databases (issue #206) (Thanks: FranΓ§ois Pietka_)
  • v1.6.0 Changes

    πŸ”‹ Features:

    • βž• Add time option for prompt (Thanks: Gustavo Castro_)
    • Suggest objects from all schemas (not just those in search_path) (Thanks: Joakim Koljonen_)
    • Casing for column headers (Thanks: Joakim Koljonen_)
    • πŸ‘ Allow configurable character to be used for multi-line query continuations. (Thanks: Owen Stephens_)
    • Completions after ORDER BY and DISTINCT now take account of table aliases. (Thanks: Owen Stephens_)
    • Narrow keyword candidates based on previous keyword. (Thanks: Γ‰tienne Bersac_)
    • Opening an external editor will edit the last-run query. (Thanks: Thomas Roten_)
    • πŸ‘Œ Support query options in postgres URIs such as ?sslcert=foo.pem (Thanks: Alexander Schmolck_)

    πŸ› Bug fixes:

    • πŸ›  Fixed external editor bug (issue #668). (Thanks: Irina Truong_).
    • πŸ’» Standardize command line option names. (Thanks: Russell Davies_)
    • Improve handling of lock_not_available error (issue #700). (Thanks: Jackson Popkin <https://github.com/jdpopkin>_)
    • πŸ›  Fixed user option precedence (issue #697). (Thanks: Irina Truong_).

    Internal changes:

    • βš™ Run pep8 checks in travis (Thanks: Irina Truong_).
    • βž• Add pager wrapper for behave tests (Thanks: Dick Marinus_).
    • Behave quit pgcli nicely (Thanks: Dick Marinus_).
    • βœ… Behave test source command (Thanks: Dick Marinus_).
    • Behave fix clean up. (Thanks: Dick Marinus_).
    • βœ… Test using behave the tee command (Thanks: Dick Marinus_).
    • 🚚 Behave remove boiler plate code (Thanks: Dick Marinus_).
    • ⚑️ Behave fix pgspecial update (Thanks: Dick Marinus_).
    • βž• Add behave to tox (Thanks: Dick Marinus_).
  • v1.5.1 Changes

    πŸ”‹ Features:

    • πŸ‘ Better suggestions when editing functions (Thanks: Joakim Koljonen_)
    • πŸ’» Command line option for --less-chatty. (Thanks: tk_)
    • βž• Added MATERIALIZED VIEW keywords. (Thanks: Joakim Koljonen_).

    πŸ› Bug fixes:

    • πŸ‘Œ Support unicode chars in expanded mode. (Thanks: Amjith Ramanujam_)
    • Fixed "set_session cannot be used inside a transaction" when using dsn. (Thanks: Irina Truong_).
  • v1.5.0 Changes

    πŸ”‹ Features:

    • ⬆️ Upgraded pgspecial to 1.7.0. (See pgspecial changelog <https://github.com/dbcli/pgspecial/blob/master/changelog.rst>_ for list of fixes)
    • βž• Add a new config setting to allow expandable mode (Thanks: Jonathan Boudreau <https://github.com/AGhost-7>_)
    • πŸ‘‰ Make pgcli prompt width short when the prompt is too long (Thanks: Jonathan Virga <https://github.com/jnth>_)
    • βž• Add additional completion for ALTER keyword (Thanks: Darik Gamble_)
    • πŸ”§ Make the menu size configurable. (Thanks Darik Gamble_)

    πŸ› Bug Fixes:

    • πŸ– Handle more connection failure cases. (Thanks: Amjith Ramanujam_)
    • πŸ›  Fix the connection failure issues with latest psycopg2. (Thanks: Amjith Ramanujam_)

    Internal Changes:

    • βž• Add testing for Python 3.5 and 3.6. (Thanks: Amjith Ramanujam_)
  • v1.4.0 Changes

    πŸ”‹ Features:

    • Search table suggestions using initialisms. (Thanks: Joakim Koljonen_).
    • πŸ‘Œ Support for table-qualifying column suggestions. (Thanks: Joakim Koljonen_).
    • Display transaction status in the toolbar. (Thanks: Joakim Koljonen_).
    • Display vi mode in the toolbar. (Thanks: Joakim Koljonen_).
    • βž• Added --prompt option. (Thanks: Irina Truong_).

    πŸ› Bug Fixes:

    • πŸ›  Fix scoping for columns from CTEs. (Thanks: Joakim Koljonen_)
    • πŸ›  Fix crash after with. (Thanks: Joakim Koljonen_).
    • πŸ›  Fix issue #603 (\i raises a TypeError). (Thanks: Lele Gaifax_).

    Internal Changes:

    • Set default data_formatting to nothing. (Thanks: Amjith Ramanujam_).
    • Increased minimum prompt_toolkit requirement to 1.0.9. (Thanks: Irina Truong_).
  • v1.3.1 Changes

    πŸ› Bug Fixes:

    • πŸ›  Fix a crashing bug due to sqlparse upgrade. (Thanks: Darik Gamble_)
  • v1.3.0 Changes

    πŸ‘ IMPORTANT: Python 2.6 is not officially supported anymore.

    πŸ”‹ Features:

    • βž• Add delimiters to displayed numbers. This can be configured via the config file. (Thanks: Sergii_).
    • πŸ›  Fix broken 'SHOW ALL' in redshift. (Thanks: Manuel Barkhau_).
    • πŸ‘Œ Support configuring keyword casing preferences. (Thanks: Darik Gamble_).
    • Add a new multi_line_mode option in config file. The values can be psql or safe. (Thanks: Joakim Koljonen_) Setting multi_line_mode = safe will make sure that a query will only be executed when Alt+Enter is pressed.

    πŸ› Bug Fixes:

    • πŸ›  Fix crash bug with leading parenthesis. (Thanks: Joakim Koljonen_).
    • βœ‚ Remove cumulative addition of timing data. (Thanks: Amjith Ramanujam_).
    • πŸ– Handle unrecognized keywords gracefully. (Thanks: Darik Gamble_)
    • πŸ›  Use raw strings in regex specifiers. This preemptively fixes a crash in Python 3.6. (Thanks Lele Gaifax_)

    Internal Changes:

    • πŸ“œ Set sqlparse version dependency to >0.2.0, <0.3.0. (Thanks: Amjith Ramanujam_).
    • XDG_CONFIG_HOME support for config file location. (Thanks: Fabien Meghazi_).
    • βœ‚ Remove Python 2.6 from travis test suite. (Thanks: Amjith Ramanujam_)
  • v1.2.0 Changes

    πŸ”‹ Features:

    • βž• Add more specifiers to pgcli prompt. (Thanks: Julien Rouhaud_). \p for port info \# for super user and \i for pid.
    • βž• Add \watch command to periodically execute a command. (Thanks: Stuart Quin_). > SELECT * FROM django_migrations; \watch 1 /* Runs the command every second */
    • βž• Add command-line option --single-connection to prevent pgcli from using multiple connections. (Thanks: Joakim Koljonen_).
    • βž• Add priority to the suggestions to sort based on relevance. (Thanks: Joakim Koljonen_).
    • πŸ”§ Configurable null format via the config file. (Thanks: Adrian Dries_).
    • βž• Add support for CTE aware auto-completion. (Thanks: Darik Gamble_).
    • βž• Add host and user information to default pgcli prompt. (Thanks: Lim H_).
    • πŸ‘ Better scoping for tables in insert statements to improve suggestions. (Thanks: Joakim Koljonen_).

    πŸ› Bug Fixes:

    • Do not install setproctitle on cygwin. (Thanks: Janus Troelsen_).
    • β†ͺ Work around sqlparse crashing after AS keyword. (Thanks: Joakim Koljonen_).
    • πŸ›  Fix a crashing bug with named queries. (Thanks: Joakim Koljonen_).
    • πŸ‘ Replace timestampz alias since AWS Redshift does not support it. (Thanks: Tahir Butt_).
    • Prevent pgcli from hanging indefinitely when Postgres instance is not running. (Thanks: Darik Gamble_)

    Internal Changes:

    • ⬆️ Upgrade to sqlparse-0.2.0. (Thanks: Tiziano MΓΌller_).
    • ⬆️ Upgrade to pgspecial 1.6.0. (Thanks: Stuart Quin_).
  • v1.1.0 Changes

    πŸ”‹ Features:

    • βž• Add support for \db command. (Thanks: Irina Truong_)

    πŸ› Bugs:

    • πŸ›  Fix the crash at startup while parsing the postgres url with port number. (Thanks: Eric Wald_)
    • πŸ›  Fix the crash with Redshift databases. (Thanks: Darik Gamble_)

    Internal Changes:

    • ⬆️ Upgrade pgspecial to 1.5.0 and above.
  • v1.0.0 Changes

    πŸ”‹ Features:

    • ⬆️ Upgrade to prompt-toolkit 1.0.0. (Thanks: Jonathan Slenders_).
    • βž• Add support for \o command to redirect query output to a file. (Thanks: Tim Sanders_).
    • βž• Add \i path completion. (Thanks: Anthony Lai_).
    • Connect to a dsn saved in config file. (Thanks: Rodrigo RamΓ­rez Norambuena_).
    • ⬆️ Upgrade sqlparse requirement to version 0.1.19. (Thanks: Fernando L. Canizo_).
    • βž• Add timestamptz to DATE custom extension. (Thanks: Fernando Mora_).
    • Ensure target dir exists when copying config. (Thanks: David Szotten_).
    • πŸ– Handle dates that fall in the B.C. range. (Thanks: Stuart Quin_).
    • Pager is selected from config file or else from environment variable. (Thanks: Fernando Mora_).
    • βž• Add support for Amazon Redshift. (Thanks: Timothy Cleaver_).
    • Add support for Postgres 8.x. (Thanks: Timothy Cleaver_ and Darik Gamble_)
    • Don't error when completing parameter-less functions. (Thanks: David Szotten_).
    • Concat and return all available notices. (Thanks: Stuart Quin_).
    • πŸ– Handle unicode in record type. (Thanks: Amjith Ramanujam_).
    • βž• Added humanized time display. Connect #396. (Thanks: Irina Truong_).
    • βž• Add EXPLAIN keyword to the completion list. (Thanks: Amjith Ramanujam_).
    • βž• Added sdist upload to release script. (Thanks: Irina Truong_).
    • Sort completions based on most recently used. (Thanks: Darik Gamble)
    • Expand '' into column list during completion. This can be triggered by hitting <tab> after the '' character in the sql while typing. (Thanks: Joakim Koljonen_)
    • βž• Add a limit to the warning about too many rows. This is controlled by a new config value in ~/.config/pgcli/config. (Thanks: AnΕΎe Pečar_)
    • πŸ‘Œ Improved argument list in function parameter completions. (Thanks: Joakim Koljonen_)
    • Column suggestions after the COLUMN keyword. (Thanks: Darik Gamble_)
    • Filter out trigger implemented functions from the suggestion list. (Thanks: Daniel Rocco_)
    • State of the art JOIN clause completions that suggest entire conditions. (Thanks: Joakim Koljonen_)
    • Suggest fully formed JOIN clauses based on Foreign Key relations. (Thanks: Joakim Koljonen_)
    • βž• Add support for \dx meta command to list the installed extensions. (Thanks: Darik Gamble_)
    • βž• Add support for \copy command. (Thanks: Catherine Devlin_)

    πŸ› Bugs:

    • πŸ›  Fix bug where config writing would leave a '~' dir. (Thanks: James Munson_).
    • πŸ›  Fix auto-completion breaking for table names with caps. (Thanks: Anthony Lai_).
    • πŸ›  Fix lexical ordering bug. (Thanks: Anthony Lai_).
    • πŸ‘‰ Use lexical order to break ties when fuzzy matching. (Thanks: Daniel Rocco_).
    • πŸ›  Fix the bug in auto-expand mode when there are no rows to display. (Thanks: Amjith Ramanujam_).
    • πŸ›  Fix broken \i after #395. (Thanks: David Szotten_).
    • πŸ›  Fix multi-way joins in auto-completion. (Thanks: Darik Gamble_)
    • Display null values as in expanded output. (Thanks: Amjith Ramanujam_).
    • πŸ‘ Robust support for Postgres version less than 9.x. (Thanks: Darik Gamble_)

    Internal Changes:

    • ⚑️ Update config file location in README. (Thanks: Ari Summer_).
    • Explicitly add wcwidth as a dependency. (Thanks: Amjith Ramanujam_).
    • Add tests for the format_output. (Thanks: Amjith Ramanujam_).
    • βœ… Lots of tests for pgcompleter. (Thanks: Darik Gamble_).
    • ⚑️ Update pgspecial dependency to 1.4.0.