On: Postgres features and tips

[blowski]

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.

[craigkerstiens → blowski]

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.

[someotherperson → craigkerstiens]

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

[awl130 → craigkerstiens]

http://wagonhq.com, which is in beta, is phenomenal

[kevinwuhoo → blowski]

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.

[jakobegger → blowski]

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

[snuxoll → blowski]

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

[nkantar → blowski]

I don't know if I'd call it good, but pgAdmin is a free/Free option that, well, works: http://www.pgadmin.org/

[dorfsmay → blowski]

DBeaver, not just Postgres but Oracle, MySQL, SQLite etc...

http://dbeaver.jkiss.org/

[reactor → dorfsmay]

second this, great tool.

[hugi → blowski]

I'm waiting for SequelPro to add Postgres support before I make the switch. It's an amazing product.

[blowski → hugi]

Any idea when that will happen?

[ceejayoz → blowski]

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

[dennyabraham → blowski]

Navicat Essentials for Postgres on OSX costs $40 and is a robust if somewhat stripped down alternative.

[andlarry → blowski]

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/

[avb → blowski]

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/