All Versions
54
Latest Version
Avg Release Cycle
60 days
Latest Release
953 days ago
Changelog History
Page 4
Changelog History
Page 4
-
v1.3.1 Changes
π Bug Fixes:
- π Fix a crashing bug due to sqlparse upgrade. (Thanks:
Darik Gamble
_)
- π Fix a crashing bug due to sqlparse upgrade. (Thanks:
-
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
orsafe
. (Thanks:Joakim Koljonen
_) Settingmulti_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
_)
- β Add delimiters to displayed numbers. This can be configured via the config file. (Thanks:
-
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
_).
- β Add more specifiers to pgcli prompt. (Thanks:
-
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.
- β Add support for
-
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
_ andDarik 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.
- β¬οΈ Upgrade to prompt-toolkit 1.0.0. (Thanks:
-
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
).
- Fixed logging in Windows by switching the location of log and history file based on OS. (Thanks: Amjith,
-
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
_). Whenon_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
_).
- Perform auto-completion refresh in background. (Thanks: Amjith,
-
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.
- Autocompletion for database name in \c and \connect. (Thanks:
-
v0.19.1 Changes
π BugFixes:
- π Fix an autocompletion bug that was crashing the completion engine when unknown keyword is entered. (Thanks:
Darik Gamble
_)
- π Fix an autocompletion bug that was crashing the completion engine when unknown keyword is entered. (Thanks:
-
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 toTrue
.- π 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.
- Wider completion menus can be enabled via the config file. (Thanks: