pgcli changelog

Changelog History

Page 1

• v3.2.0 Changes

  🚀 Release date: 2021/08/23

  🔋 Features:

  • ⚡️ Consider update queries destructive and issue a warning. Change destructive_warning setting to all|moderate|off, vs true|false. (#1239)
  • Skip initial comment in .pg_session even if it doesn't start with '#'
  • Include functions from schemas in search_path. (Amjith Ramanujam_)

  🐛 Bug fixes:

  • 🛠 Fix issue where syntax_style config value would not have any effect. (#1212)
  • 🛠 Fix crash because of not found InputMode.REPLACE_SINGLE with prompt-toolkit < 3.0.6
  • 🛠 Fix comments being lost in config when saving a named query. (#1240)
  • 🛠 Fix IPython magic for ipython-sql >= 0.4.0
  • 🛠 Fix pager not being used when output format is set to csv. (#1238)
  • Add function literals random, generate_series, generate_subscripts
  • 🛠 Fix ANSI escape codes in first line make the cli choose expanded output incorrectly
  • 🛠 Fix pgcli crashing with virtual pgbouncer database. (#1093)

• v3.1.0 Changes

  🔋 Features:

  • 👉 Make the output more compact by removing the empty newline. (Thanks: laixintao_)
  • ➕ Add support for using pspg as a pager (#1102)
  • ⚡️ Update python version in Dockerfile
  • 👌 Support setting color for null, string, number, keyword value
  • 👌 Support Prompt Toolkit 2
  • 👌 Support sqlparse 0.4.x
  • ⚡️ Update functions, datatypes literals for auto-suggestion field
  • ➕ Add suggestion for schema in function auto-complete

  🐛 Bug fixes:

  • 🛠 Minor typo fixes in pgclirc. (Thanks: anthonydb_)
  • 🛠 Fix for list index out of range when executing commands from a file (#1193). (Thanks: Irina Truong_)
  • 🚚 Move from humanize to pendulum for displaying query durations (#1015)
  • More explicit error message when connecting using DSN alias and it is not found.

• v3.0.0 Changes

  April 10, 2020

  🔋 Features:

  • Add __main__.py file to execute pgcli as a package directly (#1123).
  • ➕ Add support for ANSI escape sequences for coloring the prompt (#1122).
  • ➕ Add support for partitioned tables (relkind "p").
  • ➕ Add support for pg_service.conf files
  • Add config option show_bottom_toolbar.

  🐛 Bug fixes:

  • 🛠 Fix warning raised for using is not to compare string literal
  • Close open connection in completion_refresher thread

  Internal:

  • ⬇️ Drop Python2.7, 3.4, 3.5 support. (Thanks: laixintao_)
  • 👌 Support Python3.8. (Thanks: laixintao_)
  • 🛠 Fix dead link in development guide. (Thanks: BrownShibaDog_)
  • ⬆️ Upgrade python-prompt-toolkit to v3.0. (Thanks: laixintao_)

• v2.2.0 Changes

  December 04, 2019

  🔋 Features:

  • ➕ Add support for ANSI escape sequences for coloring the prompt (#1123).
  • ➕ Add \\G as a terminator to sql statements that will show the results in expanded mode. This feature is copied from mycli. (Thanks: Amjith Ramanujam_)
  • ✂ Removed limit prompt and added automatic row limit on queries with no LIMIT clause (#1079) (Thanks: Sebastian Janko_)
  • Function argument completions now take account of table aliases (#1048). (Thanks: Owen Stephens_)

  🐛 Bug fixes:

  • Error connecting to PostgreSQL 12beta1 (#1058). (Thanks: Irina Truong_ and Amjith Ramanujam_)
  • Empty query caused error message (#1019) (Thanks: Sebastian Janko_)
  • History navigation bindings in multiline queries (#1004) (Thanks: Pedro Ferrari_)
  • Can't connect to pgbouncer database (#1093). (Thanks: Irina Truong_)
  • 🛠 Fix broken multi-line history search (#1031). (Thanks: Owen Stephens_)
  • 🛠 Fix slow typing/movement when multi-line query ends in a semicolon (#994). (Thanks: Owen Stephens_)
  • 🛠 Fix for PQconninfo not available in libpq < 9.3 (#1110). (Thanks: Irina Truong_)

  Internal:

  • Add optional but default squash merge request to PULL_REQUEST_TEMPLATE

• v2.1.1 Changes

  May 31, 2019

  🐛 Bug fixes:

  • Escape switches to VI navigation mode when not canceling completion popup. (Thanks: Nathan Verzemnieks_)
  • Allow application_name to be overridden. (Thanks: raylu_)
  • 🛠 Fix for "no attribute KeyringLocked" (#1040). (Thanks: Irina Truong_)
  • Pgcli no longer works with password containing spaces (#1043). (Thanks: Irina Truong_)
  • Load keyring only when keyring is enabled in the config file (#1041). (Thanks: Zhaolong Zhu_)
  • 🚀 No longer depend on sqlparse as being less than 0.3.0 with the release of sqlparse 0.3.0. (Thanks: VVelox_)
  • 🛠 Fix the broken support for pgservice . (Thanks: Xavier Francisco_)
  • Connecting using socket is broken in current master. (#1053). (Thanks: Irina Truong_)
  • 👍 Allow usage of newer versions of psycopg2 (Thanks: Telmo "Trooper"_)
  • ⚡️ Update README in alignment with the usage of newer versions of psycopg2 (Thanks: Alexander Zawadzki_)

  Internal:

  • ➕ Add python 3.7 to travis build matrix. (Thanks: Irina Truong_)
  • Apply black to code. (Thanks: Irina Truong_)

• v2.1.0 Changes

  April 06, 2019

  🔋 Features:

  • Keybindings for closing the autocomplete list. (Thanks: easteregg_)
  • Reconnect automatically when server closes connection. (Thanks: Scott Brenstuhl_)

  🐛 Bug fixes:

  • Avoid error message on the server side if hstore extension is not installed in the current database (#991). (Thanks: Marcin Cieślak_)
  • 📦 All pexpect submodules have been moved into the pexpect package as of version 3.0. Use pexpect.TIMEOUT (Thanks: Marcin Cieślak_)
  • Resizing pgcli terminal kills the connection to postgres in python 2.7 (Thanks: Amjith Ramanujam_)
  • 🛠 Fix crash retrieving server version with --single-connection. (Thanks: Irina Truong_)
  • Cannot quit application without reconnecting to database (#1014). (Thanks: Irina Truong_)
  • 0️⃣ Password authentication failed for user "postgres" when using non-default password (#1020). (Thanks: Irina Truong_)

  Internal:

  • (Fixup) Clean up and add behave logging. (Thanks: Marcin Cieślak, Dick Marinus)
  • ✅ Override VISUAL environment variable for behave tests. (Thanks: Marcin Cieślak_)
  • ✂ Remove build dir before running sdist, remove stray files from wheel distribution. (Thanks: Dick Marinus_)
  • 🛠 Fix unit tests, unhashable formatted text since new python prompttoolkit version. (Thanks: Dick Marinus_)

• v2.0.4

  July 22, 2018

• v2.0.2 Changes

  January 03, 2019

  🔋 Features:

  • 👍 Allows passing the -u flag to specify a username. (Thanks: Ignacio Campabadal_)
  • 🛠 Fix for lag in v2 (#979). (Thanks: Irina Truong_)
  • 👌 Support for multihost connection string that is convenient if you have postgres cluster. (Thanks: Mikhail Elovskikh_)

  Internal:

  • ➕ Added tests for special command completion. (Thanks: Amjith Ramanujam_)

• v2.0.1 Changes

  November 19, 2018

  🐛 Bug fixes:

  • Tab press on an empty line increases the indentation instead of triggering the auto-complete pop-up. (Thanks: Artur Balabanov_)
  • 🛠 Fix for loading/saving named queries from provided config file (#938). (Thanks: Daniel Egger_)
  • Set default port in connect_uri when none is given. (Thanks: Daniel Egger_)
  • 🛠 Fix for error listing databases (#951). (Thanks: Irina Truong_)
  • Enable Ctrl-Z to suspend the app (Thanks: Amjith Ramanujam_).
  • 🛠 Fix StopIteration exception raised at runtime for Python 3.7 (Thanks: Amjith Ramanujam_).

  Internal:

  • 🌲 Clean up and add behave logging. (Thanks: Dick Marinus_)
  • Require prompt_toolkit>=2.0.6. (Thanks: Dick Marinus_)
  • 👌 Improve development guide. (Thanks: Ignacio Campabadal_)

• v2.0.0 Changes

  September 29, 2018

  • Update to prompt-toolkit 2.0. (Thanks: Jonathan Slenders, Dick Marinus, Irina Truong_)

• 1
• 2
• 3
• 4
• 5
• Next ›
• Last »