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

Changelog History
Page 4

  • 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.
  • v0.20.1 Changes

    πŸ› Bug Fixes:

    • Fixed logging in Windows by switching the location of log and history file based on OS. (Thanks: Amjith, Darik Gamble, Irina Truong).
  • v0.20.0 Changes

    πŸ”‹ Features:

    • Perform auto-completion refresh in background. (Thanks: Amjith, Darik Gamble, Irina Truong). When the auto-completion entries are refreshed, the update now happens in a background thread. This means large databases with thousands of tables are handled without blocking.
    • βž• Add CONCURRENTLY to keyword completion. (Thanks: Johannes Hoff_).
    • βž• Add support for \h command. (Thanks: Stuart Quin_). This is a huge deal. Users can now get help on an SQL command by typing: \h COMMAND_NAME in the pgcli prompt.
    • βž• Add support for \x auto. (Thanks: Stuart Quin_). \\x auto will automatically switch to expanded mode if the output is wider than the display window.
    • Don't hide functions from pg_catalog. (Thanks: Darik Gamble_).
    • Suggest set-returning functions as tables. (Thanks: Darik Gamble_). Functions that return table like results will now be suggested in places of tables.
    • Suggest fields from functions used as tables. (Thanks: Darik Gamble_).
    • Using pgspecial as a separate module. (Thanks: Irina Truong_).
    • πŸ‘‰ Make "enter" key behave as "tab" key when the completion menu is displayed. (Thanks: Matheus Rosa_).
    • πŸ‘Œ Support different error-handling options when running multiple queries. (Thanks: Darik Gamble_). When on_error = STOP in the config file, pgcli will abort execution if one of the queries results in an error.
    • Hide the password displayed in the process name in ps. (Thanks: Stuart Quin_)

    πŸ› Bug Fixes:

    • πŸ›  Fix the ordering bug in \\d+ display, this bug was displaying the wrong table name in the reference. (Thanks: Tamas Boros_).
    • Only show expanded layout if valid list of headers provided. (Thanks: Stuart Quin_).
    • πŸ›  Fix suggestions in compound join clauses. (Thanks: Darik Gamble_).
    • πŸ›  Fix completion refresh in multiple query scenario. (Thanks: Darik Gamble_).
    • πŸ›  Fix the broken timing information.
    • πŸ›  Fix the removal of whitespaces in the output. (Thanks: Jacek Wielemborek_)
    • πŸ›  Fix PyPI badge. (Thanks: Artur Dryomov_).

    πŸ‘Œ Improvements:

    • 🚚 Move config file to ~/.config/pgcli/config instead of ~/.pgclirc (Thanks: inkn_).
    • 🚚 Move literal definitions to standalone JSON files. (Thanks: Darik Gamble_).

    Internal Changes:

    • πŸ‘Œ Improvements to integration tests to make it more robust. (Thanks: Irina Truong_).
  • v0.19.2 Changes

    πŸ”‹ Features:

    • Autocompletion for database name in \c and \connect. (Thanks: Darik Gamble_).
    • πŸ‘Œ Improved multiline query support by correctly handling open quotes. (Thanks: Darik Gamble_).
    • βž• Added \pager command.
    • ✨ Enhanced \i to run multiple queries and display the results for each of them
    • βž• Added keywords to suggestions after WHERE clause.
    • Enabled autocompletion in named queries. (Thanks: Irina Truong_).
    • πŸ’» Path to .pgclirc can be specified in command line. (Thanks: Irina Truong_).
    • Added support for pg_service_conf file. (Thanks: Irina Truong_).
    • βž• Added custom styles. (Contributor: Darik Gamble_).

    Internal Changes:

    • βœ… More completer test cases. (Thanks: Darik Gamble_).
    • ⚑️ Updated sqlparse version from 0.1.14 to 0.1.16. (Thanks: Darik Gamble_).
    • Upgraded to prompt_toolkit 0.46. (Thanks: Jonathan Slenders_).

    πŸ›  BugFixes:

    • πŸ›  Fixed the completer crashing on invalid SQL. (Thanks: Darik Gamble_).
    • πŸ›  Fixed unicode issues, updated tests and fixed broken tests.
  • v0.19.1 Changes

    πŸ›  BugFixes:

    • πŸ›  Fix an autocompletion bug that was crashing the completion engine when unknown keyword is entered. (Thanks: Darik Gamble_)
  • v0.19.0 Changes

    πŸ”‹ Features:

    • Wider completion menus can be enabled via the config file. (Thanks: Jonathan Slenders_)

    Open the config file (~/.pgclirc) and check if you have wider_completion_menu option available. If not add it in and set it to True.

    • πŸ“‡ Completion menu now has metadata information such as schema, table, column, view, etc., next to the suggestions. (Thanks: Darik Gamble_)
    • Customizable history file location via config file. (Thanks: Γ‡ağatay YΓΌksel_)

    Add this line to your config file (~/.pgclirc) to customize where to store the history file.

    ::

    history_file = /path/to/history/file

    • βž• Add support for running queries from a file using \i special command. (Thanks: Michael Kaminsky_)

    πŸ›  BugFixes:

    • 0️⃣ Always use utf-8 for database encoding regardless of the default encoding used by the database.
    • πŸ›  Fix for None dereference on \d schemaname. with sequence. (Thanks: Nathan Jhaveri_)
    • πŸ›  Fix a crashing bug in the autocompletion engine for some JOIN queries.
    • πŸ– Handle KeyboardInterrupt in pager and not quit pgcli as a consequence.

    Internal Changes:

    • βž• Added more behaviorial tests (Thanks: Irina Truong_)
    • βž• Added code coverage to the tests. (Thanks: Irina Truong_)
    • βœ… Run behaviorial tests as part of TravisCI (Thanks: Irina Truong_)
    • Upgraded prompt_toolkit version to 0.45 (Thanks: Jonathan Slenders_)
    • ⚑️ Update the minumum required version of click to 4.1.