News for hackers. Stuff that matters.
Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by amjith on Tuesday January 06, 2015 @10:56AM (#8844899)
I'm the author of pgcli.

There is an FAQ page: http://pgcli.com/faq

I'll be happy to answer questions here as well.

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by HCIdivision17 on Tuesday January 06, 2015 @02:16PM (#8846327)
You mentioned you'd like to know if it works in Windows, and I think it does!

My setup is a bit of a one-off. I'm running it inside ConEmu, with the environment initialized from a batch script. That way, my whole setup is portable. Postgres is fired up with a tab in ConEmu (cleaned up once ConEmu closes by the waiting script that spawned it). None of it has admin, but seems to allow me to bootstrap any tool I'd like to use. I also have MinGW and the GNU tools that were compiled for Windows. So from now on, I'll have pgcli fire up instead of just psql when that ConEmu tab opens.

I have to say it's a pleasure to see it Just Work. I haven't done anything clever yet, just some basic fiddlin'. But it's really quite nice to have a pretty CLI tool for PG in Windows!

EDIT: whoops, wrong tool name.

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by amjith on Tuesday January 06, 2015 @05:25PM (#8847518)
Thank you for testing it on Windows. I just got an Azure instance, so I should start doing proper tests on Windows before releases. Thank you!
Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by jaytaylor on Tuesday January 06, 2015 @12:17PM (#8845495)
Wow, I just installed it and tested it out - pgcli is remarkable! This is going to be revolutionary for my psql command-line forays! The auto-complete is fantastic.

The source code is available on GH: https://github.com/amjith/pgcli

OP: why no "Fork Me" banner? ;)

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by amjith on Tuesday January 06, 2015 @12:21PM (#8845531)
I'm using Pelican static generator to create the site. Once I figure out how to add the "Fork Me!" banner, I'll add that in.

The link to the GH repo is on the home page. I figured that makes it obvious, but perhaps not?

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by jaytaylor on Tuesday January 06, 2015 @12:34PM (#8845648)
It was a little hard to find the link since it was buried at the bottom in "social" alongside twitter.

Again, this is truly awesome work. Can you comment on what inspired you to create pgcli?

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by amjith on Tuesday January 06, 2015 @12:41PM (#8845709)
Copied from FAQ.

I'm a huge fan of CLIs. Especially REPLs. When I first encountered BPython (http://www.bpython-interpreter.org/), I fell in love with it. BPython is a Python REPL that has auto-completion, syntax-highlighting and displays the docstring of functions as you type. Once you get used to that level of pampering, all other REPLs start to look like Dumb Terminals.

When I started using psql for interacting with my Postgres database, I yearned for a BPython equivalent for psql.

One fine day I got a twitter DM from Jonathan Slenders asking me if I'd be interested in trying a new Python library that he's working on called Python-Prompt-Toolkit. This library provided a way to write CLIs without having to deal with curses and had the requisite tools for doing auto-completion and syntax-highlighting. So I jumped at the opportunity to try it out. After I got myself familiarized, I started writing pgcli to scratch my own itch.

So this app exists because Jonathan was kind enough to request my feedback.

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by vectorpush on Tuesday January 06, 2015 @01:39PM (#8846144)
This is really great man, thanks. I had simply accepted the pgsql client for what it is, but you took it as an opportunity to innovate. Kudos!
Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by tgkokk on Tuesday January 06, 2015 @01:31PM (#8846095)
For the request on the homepage for a Homebrew formula:

From [1]:

> Homebrew generally won't accept libraries that can be installed correctly with `pip install foo`.

[1]: https://github.com/Homebrew/homebrew/blob/master/share/doc/h...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:33PM (#8846878)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by amjith on Tuesday January 06, 2015 @01:36PM (#8846128)
Yes. But pgcli is not a python library, it's an application that happens to be written in python.

> Homebrew is happy to accept applications that are built in Python, whether the apps are available from PyPI or not.

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:33PM (#8846873)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:33PM (#8846867)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:32PM (#8846859)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:32PM (#8846854)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:32PM (#8846847)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:32PM (#8846846)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:32PM (#8846845)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...

Re:Show HN: Pgcli – A CLI for Postgres with auto-completion ... by lloeki on Tuesday January 06, 2015 @03:32PM (#8846843)
Example: duplicity[0] is available via homebrew.

[0]: https://github.com/Homebrew/homebrew/blob/master/Library/For...