Other articles


  1. Release v2.0.2

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using:

    $ pip install -U pgcli
    

    After the update of pgcli to use prompt-toolkit 2.0, there were quite a few complaints about performance, in particular, slow autocompletions. This release attempts …

    read more
  2. Release v1.10.0

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using:

    $ pip install -U pgcli
    

    This release adds new special commands \ev and \ef, more table formats, and a --user alias for --username option, to be compatible with psql. Pgcli …

    read more
  3. Sensible Defaults

    When I first set out to create pgcli, my goal was to design a Postgresql client that shipped with sensible defaults. It shouldn't require fiddling with config files to enable features.

    How did we do on that goal? This is one of those subjective goals that is not so easy …

    read more
  4. Release v0.20.0

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This version adds support for \\h command and \x auto command. Two very important commands that bring us …

    read more
  5. Release v0.19.2

    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 …
    read more
  6. Release v0.19.0

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This release comes with metadata information in the completion menus. Now you can see whether a completion suggestion …

    read more
  7. Release v0.18.0

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This release comes with the ability to save favorite queries, fuzzy matching in auto-completion, new special commands (\#), fix …

    read more
  8. Release v0.17.0

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This release comes with the latest version of prompt_tookit, improved auto-completion support, better matching algorithm in auto-completion, new …

    read more
  9. Screencast: pgcli basics

    I created a screencast to showcase some of the basic features of pgcli.

    pgcli is a client for postgres that can do autocompletion and syntax highlighting.

    This video covers:

    • Installation
    • Launching pgcli
    • Switching databases
    • Basic auto-completion for SELECT, CREATE, INSERT and JOIN statements.
    • Expanded output
    • Multi-line mode

    Video:

    If there …

    read more
  10. Release v0.16.3

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This is a minor bug-fix release that fixes the syntax-highlighting of various Postgres specific keywords and adds the …

    read more
  11. Release v0.16.2

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This is a bug-fix release that improves auto-completion and formatting of large numbers in the output.

    Bug Fixes …

    read more
  12. Release v0.16.1

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This is a minor bug-fix release that fixes unicode issues with hstore.

    Bug Fixes:

    • Fix unicode issues with …
    read more
  13. Release v0.16.0

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This release adds Vi-keybindings, improvements to special commands (new additions ds and df) and fix a lot of …

    read more
  14. Release v0.15.X

    Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:

    $ pip install -U pgcli
    

    Check detailed instructions if you're having difficulty.

    This version adds more color schemes to the syntax highlighting. An attempt to add support for PyPy by …

    read more
  15. Embedding pgcli in IPython

    IPython is an interactive shell for Python that is well-suited to do data-analysis. It has integration for plotting, data-analysis libraries, parallel computing etc.

    IPython-sql is an IPython extension that provides an easy way to load data from a database into the ipython environment to do the data-analysis. Here's an example …

    read more