I'm the author of pgcli.<p>There is an FAQ page: <a href="http://pgcli.com/faq" rel="nofollow">http://pgcli.com/faq</a><p>I'll be happy to answer questions here as well.
This looks really nice, especially the colors.<p>As a reminder/heads up, you can often get simple command line editing and completion in tools like psql in a bash-like environment, just by having a .inputrc file in your home directory. Basically anything that uses readline, like bash, psql, ipython, etc.<p>Extra benefit, you don't need to set -o vi (or the other flavor) in your .bashrc or on the command line; anything that uses readline (including bash and many other cli interfaces) will read the .inputrc file and do what it says. I'm often pleasantly surprised that a new cli tool uses my .inputrc.<p><a href="http://linux.die.net/man/3/readline" rel="nofollow">http://linux.die.net/man/3/readline</a><p><a href="https://www.gnu.org/software/bash/manual/bashref.html#Command-Line-Editing" rel="nofollow">https://www.gnu.org/software/bash/manual/bashref.html#Comman...</a><p>You can easily add the capability to command line tools that you write. For example:<p><a href="https://docs.python.org/2/library/readline.html" rel="nofollow">https://docs.python.org/2/library/readline.html</a>
Awesome! I made a package for Arch Linux and stuck it into AUR: <a href="https://aur.archlinux.org/packages/pgcli/" rel="nofollow">https://aur.archlinux.org/packages/pgcli/</a>
Looks great! Just reported an incompatibility with Unicode.<p>Also, is it possible to tweak the autocompletion so that hitting Enter selects the first offered completion? Right now, you have to hit tab or use the arrow keys to select.<p>A Homebrew formula would be great.
Does this work with emacs? I love the integration of psql and emacs, but this would be even better. <a href="http://www.emacswiki.org/emacs/SqlMode" rel="nofollow">http://www.emacswiki.org/emacs/SqlMode</a>
Based on 3 minute testing, I like, thanks.<p>If someone tries to install this on ubuntu with just the quick start instructions and fails, note that you need to<p>sudo apt-get install libpq-dev<p>Obviously, this is told in the more detailed install instructions.
I actually work on a piece of software for creating sql charts from the command line (<a href="http://www.sqldashboards.com/help/sqlchart-command-line-sql-chart-generator" rel="nofollow">http://www.sqldashboards.com/help/sqlchart-command-line-sql-...</a>),this is brilliant! Thanks.
Looks pretty slick, I'll give it try when I get home.<p>I'll go ahead and ask, since I'm probably not the only one thinking it: will there be a MySQL version? ;)<p>EDIT: oh, and I guess the name wouldn't be very fitting for a MySQL cli...
This is cool! Thanks for sharing.<p>Considering I'm new to Postgres (been on MySQL for too many years), this is definitely making my life easier because of the autocomplete :)<p>But a question for you: how does this help someone who's a power user of Postgres?