News for hackers. Stuff that matters.
Re:Postgres features and tips by blowski on Tuesday December 29, 2015 @03:58PM (#10809032)
Are there any good Postgres GUIs for OSX?

SequelPro is incredible - easy to use, beautiful, reliable, powerful - but it only works with MySQL (or MariaDB). I've tried Toad but it's very buggy and ugly. The AppStore has SQLPro for Postgres, but I've not heard any reviews, so I'm reticent to spend $30. I've used a Navicat trial for MySQL and it was good but costs around $200.

Re:Postgres features and tips by craigkerstiens on Tuesday December 29, 2015 @04:12PM (#10809094)
Here's a comment from myself just a few days ago that highlights a few of them - https://news.ycombinator.com/item?id=10804931

And actually content copied as well to make it easier to digest:

If you're looking for a list of other clients some of the others ones include:

- Postico OSX - https://itunes.apple.com/us/app/postico/id1031280567?ls=1&mt...

- JackDB (web based) - https://www.jackdb.com/

- SQL Pro for Postgres - http://www.hankinsoft.com/SQLProPostgres/

- PGAdmin - Slightly outdated but still feature rich and fully cross platform - http://www.pgadmin.org/

And of course there's always psql which is all CLI, but incredibly flexible.

Re:Postgres features and tips by stevenjohns on Tuesday December 29, 2015 @11:46PM (#10810756)
+1 for PGAdmin. I've been using it for several weeks and it's been pretty good, although it does have a couple of flaws. One of them appears to be an OSX issue, though, where opening tables sometimes throws part of the window (the top bar) outside of the screen (and the only way I've found to fix it is to click on Window > Zoom).
Re:Postgres features and tips by awl130 on Tuesday December 29, 2015 @09:27PM (#10810378)
http://wagonhq.com, which is in beta, is phenomenal
Re:Postgres features and tips by kevinwuhoo on Tuesday December 29, 2015 @04:16PM (#10809114)
I recently bought a license to Postico (https://eggerapps.at/postico/) which is the successor to PG Commander. Switched from pgAdmin which is functional, but Postico's UI is nicer.
Re:Postgres features and tips by jakobegger on Wednesday December 30, 2015 @02:55AM (#10811226)
There are lots. The best is obviously the client I'm working on, Postico.

I've tried to compile a list of OS X Postgres clients in the docs for Postgres.app: http://postgresapp.com/documentation/gui-tools.html

If you know of any other, let me know.

There's also the list of GUI tools in the wiki: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...

Re:Postgres features and tips by snuxoll on Tuesday December 29, 2015 @05:07PM (#10809389)
JetBrains' DataGrip (or any of their IDE's if you have them) is really nice, I've been using it in tandem with PgAdmin (for general maintenance tasks since it has a GUI for some common stuff like permissions).
Re:Postgres features and tips by nkantar on Tuesday December 29, 2015 @04:01PM (#10809044)
I don't know if I'd call it good, but pgAdmin is a free/Free option that, well, works: http://www.pgadmin.org/
Re:Postgres features and tips by dorfsmay on Tuesday December 29, 2015 @06:53PM (#10809881)
DBeaver, not just Postgres but Oracle, MySQL, SQLite etc...

http://dbeaver.jkiss.org/

Re:Postgres features and tips by reactor on Tuesday December 29, 2015 @07:43PM (#10810077)
second this, great tool.
Re:Postgres features and tips by hugi on Tuesday December 29, 2015 @04:13PM (#10809098)
I'm waiting for SequelPro to add Postgres support before I make the switch. It's an amazing product.
Re:Postgres features and tips by blowski on Tuesday December 29, 2015 @04:26PM (#10809173)
Any idea when that will happen?
Re:Postgres features and tips by ceejayoz on Tuesday December 29, 2015 @04:35PM (#10809225)
I'm experimenting with https://eggerapps.at/postico/ currently and it's pretty nice. Fairly similar to Sequel Pro in a lot of ways (which I miss too when in Postgres-world).
Re:Postgres features and tips by dennyabraham on Tuesday December 29, 2015 @04:39PM (#10809245)
Navicat Essentials for Postgres on OSX costs $40 and is a robust if somewhat stripped down alternative.
Re:Postgres features and tips by andlarry on Tuesday December 29, 2015 @06:46PM (#10809852)
I recommend and use sqlworkbench, which is great as long as you don't work for one of the govts disallowed by the license (which is apache otherwise) http://www.sql-workbench.net/
Re:Postgres features and tips by avb on Tuesday December 29, 2015 @05:35PM (#10809534)
I'll chime in with another nod to Postico. I've been using it the last few months and really like it.

https://eggerapps.at/postico/