4 ms·
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'v
by blowski 11y ago
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.
- andlarry 11y agoI 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/ http://www.sql-workbench.net/
- dorfsmay 11y agoDBeaver, not just Postgres but Oracle, MySQL, SQLite etc... http://dbeaver.jkiss.org/ http://dbeaver.jkiss.org/
- reactor 11y agosecond this, great tool.
- nkantar 11y agoI don't know if I'd call it good, but pgAdmin is a free/Free option that, well, works: http://www.pgadmin.org/ http://www.pgadmin.org/
- craigkerstiens 11y agoHere's a comment from myself just a few days ago that highlights a few of them - https://news.ycombinator.com/item?id=10804931 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=12 https://itunes.apple.com/us/app/postico/id1031280567?ls=1&mt... - JackDB (web based) - https://www.jackdb.com/ https://www.jackdb.com/ - SQL Pro for Postgres - http://www.hankinsoft.com/SQLProPostgres/ http://www.hankinsoft.com/SQLProPostgres/ - PGAdmin - Slightly outdated but still feature rich and fully cross platform - http://www.pgadmin.org/ http://www.pgadmin.org/ And of course there's always psql which is all CLI, but incredibly flexible.
- awl130 11y agohttp://wagonhq.com http://wagonhq.com, which is in beta, is phenomenal
- stevenjohns 11y ago+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).
- hugi 11y agoI'm waiting for SequelPro to add Postgres support before I make the switch. It's an amazing product.
- blowski 11y agoAny idea when that will happen?
- kevinwuhoo 11y agoI recently bought a license to Postico (https://eggerapps.at/postico/ https://eggerapps.at/postico/) which is the successor to PG Commander. Switched from pgAdmin which is functional, but Postico's UI is nicer.
- ceejayoz 11y agoI'm experimenting with https://eggerapps.at/postico/ 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 11y agoNavicat Essentials for Postgres on OSX costs $40 and is a robust if somewhat stripped down alternative.
- snuxoll 11y agoJetBrains' 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).
- avb 11y agoI'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/ https://eggerapps.at/postico/
- jakobegger 11y agoThere 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 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_PostgreSQL_GUI_Tools https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...