Hacker News Reader

Comment by TylerE | Hacker News Reader

Huh? There's the great free PGAdmin which is WAY better than any of the web-based tools, and it has built-in SSH tunneling so it's easy to use against a remote server.

View on HN

PGAdmin is unspeakably awful. I run a Mac and it was very painful going from the world of Sequel Pro (for MySQL) to the awful, awful, terrible pgAdmin.

I ended up buying NaviCat Essentials, which is considerably better but still not perfect.

What do you find to be wrong with it? It's always done the job well for me, whereas Sequel Pro, while a prettier face, and useable enough, manages to crash at least once a day.

PGAdmin crashes regularly, and in a very annoying (and stupid!) move blocks the UI for all the windows on some database operations e.g. adding indexes. It also blocks the UI when it's processing the results of a db query, which can be slow if there is a lot of data being returned. The interface is sort-of ok though.

Sad to hear that hasn't been fixed since I left a couple of years ago...

I don't see how that's "unspeakable bad, terrible, terrible". Latest versions crash a lot less and if you really need to use UI during long database queries you can run another instance of pgadmin. It's still very useful and powerful tool.

Well, SequelPro at least started adding support for Postgres[0], but it's hard to tell how far along it is. Most of the commits in that tree seem to be from last September, with a smattering from January and May of this year.

[0]: https://code.google.com/p/sequel-pro/source/browse/#svn%2Ftr...

This thing? http://www.pgadmin.org/

This is why I hate using Postgres despite it being such an amazing database internally.

PGAdmin is everything that's wrong with database tools rolled into an executable.

If you dont mind using eclipse, you can use 'toad' eclipse plugin, which is really good.

I'd say it _almost_ has SSH tunneling built in. They're 95.418% there. It's still hardcoded to only use port 22. You can't specify another port. In my case, I have to hop through other machines and if I have SSHd running on my local box, I can't use their SSH tunneling.

Workaround, why not making the tunnel yourself?

ssh -L5555:127.0.0.1:5432 host

Then you have it on your local 5555.

Reply on news.ycombinator.com