Pgcli
Dev tools
database command line client
SHOW HN2015
227points
52comments
#78of 2,565 in 2015
Top 4%of 2015 by points
How HN took it
LovedMost comments that take a side are positive
9 positive, 24 neutral or asking, 3 mixed, 1 critical, out of 37 comments about the project. Thread score +0.30.
Execution: 3 for, 1 againstIdea: 2 for, 0 againstDesign: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Auto-completion is fantastic and makes psql easier to use
From 3 comments
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…
jaytaylor on HNTried it. It's wonderful. I think it will replace psql quickly, at least in my workflow.
pmontra on HNThis is cool! Thanks for sharing. Considering I'm new to Postgres (been on MySQL for too many years), this is definitely making my life easier because of the autocomplete :) But…
ravipratapm on HN
Attractive colors and syntax highlighting
From 1 comment
This looks really nice, especially the colors. As a reminder/heads up, you can often get simple command line editing and completion in tools like psql in a bash-like environment,…
a3n on HN
Works well on Windows
From 1 comment
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…
HCIdivision17 on HN
Objections
Does not handle non-ASCII characters well
From 2 comments
Looks great! Just reported an incompatibility with Unicode. Also, is it possible to tweak the autocompletion so that hitting Enter selects the first offered completion? Right…
lobster_johnson on HNAh. I was wondering why it was returning no results for any of the tables I was selecting data from. I've been purposefully filling this database with non-ascii characters during…
mike-cardwell on HN
Homebrew formula not yet available
From 2 comments
Looks great! Just reported an incompatibility with Unicode. Also, is it possible to tweak the autocompletion so that hitting Enter selects the first offered completion? Right…
lobster_johnson on HNFor 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]:…
tgkokk on HN
Requests
Support expanded display (\x) as in psql
From 3 comments
This is great Is there support or planned support for expanded display? (\x in psql)
pca2 on HNThis is great Is there support or planned support for expanded display? (\x in psql)
pca2 on HNThis is great Is there support or planned support for expanded display? (\x in psql)
pca2 on HN
Show tables from schemas other than public in autocomplete
From 1 comment
Sorry, but how to see tables from other schemas besides public in the FROM clause autocomplete?
xfalcox on HN
Enter key selects the first completion
From 1 comment
Looks great! Just reported an incompatibility with Unicode. Also, is it possible to tweak the autocompletion so that hitting Enter selects the first offered completion? Right…
lobster_johnson on HN
Fork Me banner and clearer repo link
From 2 comments
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…
jaytaylor on HNIt 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…
jaytaylor on HN
MySQL or SQLite version
From 2 comments
Looks pretty slick, I'll give it try when I get home. I'll go ahead and ask, since I'm probably not the only one thinking it: will there be a MySQL version? ;) EDIT: oh, and I…
IbJacked on HNDoes anyone know something similar, but for mysql?
klaussilveira on HN
Questions
How does it help power users of Postgres?
From 1 comment
This is cool! Thanks for sharing. Considering I'm new to Postgres (been on MySQL for too many years), this is definitely making my life easier because of the autocomplete :) But…
ravipratapm on HN
Does it work with Emacs sql-mode?
From 1 comment
Does this work with emacs? I love the integration of psql and emacs, but this would be even better. http://www.emacswiki.org/emacs/SqlMode
rlvesco7 on HN
How to make it the default handler for a Heroku database?
From 1 comment
Lazyweb: is there a way to get this to be the default handler for connecting to my heroku db?
asolove on HN
Alternatives named
sqlpython
From 1 comment
Did you try https://pypi.python.org/pypi/sqlpython? It's not quite the same as pgcli but I took some inspiration from that for auto-completion.
amjith on HN
Emacs sql-mode with emacs-assistant
From 1 comment
I have build https://github.com/antoineB/emacs-assistant to work with sql-mode it provide a simple completion for table and columns. For now it serve me well.
bad_login on HN