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 version comes with quite a few fixes and a couple of nice usability improvements, including automatic reconnect.
Today we are happy to announce the launch of LiteCLI!
LiteCLI is a user-friendly CommandLine client for SQLite database.
It is based on the popular pgcli and mycli projects.
LiteCLI is written in python using the wonderful prompt-toolkit library. It is cross-platform compatible and it is tested on Linux, MacOS …
read morePgcli 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 morePgcli 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 pgcli release has only one feature in it: migration to Python Prompt Toolkit 2.0. The migration was non-trivial, because prompt-toolkit was reworked almost …
read morePgcli 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
A very small release this time, but coming next is pgcli migration to Python Prompt Toolkit 2.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
Do you love colorful, terminal applications?
Are you going to Pycon this year?
You can't afford to miss the DBCLI booth at PyCon.
We are an OpenSource org that builds commandline database clients with modern features. Auto-completion, syntax highlighting and friendly UI.
DBCLI is the umbrella org that builds pgcli …
read morePgcli 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 \pset pager and \T to control output, as well as --list-dsn, and we just welcomed a new contributor, Frederic Aoustin. Updated pgspecial …
read morePgcli 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
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
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
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
Check detailed instructions if you're having difficulty.
About 2 years ago I (Amjith) made a modest announcement about launching pgcli a CLI
client for Postgres with auto-completion. Since then pgcli has grown at a
tremendous pace. We have over 4900 stars on github, released 39 versions,
merged 320 pull requests from over 60 different contributors. We established …
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
Check detailed instructions if you're having difficulty.
This is a major update with a ton of new features a lot of bug fixes. Some of …
read morePgcli 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 to fix pgcli crashing on startup in Windows.
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 moreThe pgspecial package is now independent and has its own place on PyPI:
The package provides an API for developers who wish to run meta-commands on PostgreSQL database without invoking the command line or rolling out their own custom solution. It is easily extendable.
Here is an example of …
read morePgcli 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 to fix a crashing bug during autocompletion.
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 morePgcli 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 morePgcli 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 moreHeroku is a popular PAAS provider that offers managed Postgres database. Heroku provides a convenience command to connect to the postgres database, which will launch psql. Now it is possible to launch pgcli instead of the default psql for heroku Postgres by installing the heroku-pg-pgcli plugin for heroku tool belt …
About a month ago, I started a new kickstarter project to create a MySQL client that can do auto-completion and syntax highlighting.
An equivalent of pgcli for the MySQL database.
Today I'm happy to announce that the kickstarter has reached it's goal and it's strongly marching towards the stretch goal …
read moreIt is my pleasure to announce the core devs of the pgcli project.
Daniel made pgcli handle JSON, bytea, and large decimal values correctly. He improved the completion matching by adding sub-string matching. His creative solution to reducing completion noise is extremely useful. He also added numerous tests …
read moreDjango web framework has a rich set of management commands. One of them is python manage.py dbshell. This will launch the default database repl and connect to the appropriate database for the web application.
Now it is possible to launch pgcli instead of the default psql for Postgres by …
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:
Video:
If there …
read moreI'm starting a project called mysql-cli.
mysql-cli will be a command line client for MySQL, with auto-completion and syntax highlighting. An equivalent of pgcli for MySQL database.
I'm raising funds for the project through kickstarter. The goal is to compensate for the development time and resources (hosting, testing infrastructure, etc …
read morePgcli 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 morePgcli 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.
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.
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 morePgcli 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 moreIPython 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 moreA huge release that adds completion support for schemas.
Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can upgrade using:
$ pip install -U pgcli
Check detailed instructions if you're having difficulty.
A small release that gets pgcli closer to being a drop in replacement for psql.
$ pip install -U pgcli
Check detailed instructions if you're having difficulty.
Pgcli was launched approximately one week ago.
It was an extremely successful launch, beyond any of my wildest imaginations.
Enough with the vanity …
A feature packed release. You can install/upgrade using
$ pip install -U pgcli
Pgcli was launched today on HackerNews and Reddit.
Pgcli is a command line interface for Postgres database that can do auto-completion and syntax-highlighting among other things. A list of features with screenshots are available on the features page.
Source is available on github: http://github.com/amjith/pgcli
read more