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 matchdjango_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
andFormat 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 typeSELECT * 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.
- β Add support for auto-completing view names. (Thanks:
-
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.
- π 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:
-
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.