Hacker News Reader

Comment by untog | Hacker News Reader

..and the site has gone down. Sounds fantastic, though- pgSQL has always been lacking in admin tools compared to MySQL.

From the URL of the screenshot linked to, it's a Wordpress installation.

A lazier sort of wag might point out that Wordpress runs on MySQL, but that would be a cheap shot unbecoming of our noble selves here at HN.

A more helpful sort might encourage the site owners to turn off the HTTP server, install WP Supercache or W3 Total Cache, then turn it back on.

Or just use a static site generator? It amazes me how many rarely updated sites use Wordpress when the people who run them are more than capable of using something like jekyl. I guess the themes ecosystem etc around Wordpress is just too big to pass up?

SSGs are good if you think of them in advance. In the short term, such as when one is unexpectedly on the HN front page, switching on caching is the biggest payoff.

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.

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.

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...

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