5 ms·

can anyone recommend a really good postgres GUI client? ive not found one yet for OSX, which is almost baffling

by jaequery 9y ago

tonyarkles 9y ago
The guys at work seem to love DataGrip from the IntelliJ folks.
megaman22 9y ago
Datagrip? I almost prefer it over SSMS for Sql Server, and it looks like its postgres support is on par.
miketery 9y ago
Postico!
auto 9y ago
We moved from pgadmin to DBeaver at work and have been pretty satisfied. It's based off Eclipse, so benefits from the windowing/panes, and being able to use any eclipse plugins. My db usage world changed the day I got vim support and auto complete in my query editor.
- omeid2 9y ago
  Based off Eclipse should be considered a disadvantage. IMHO Eclipse on par with Electron in terms of being a CPU and Memory hog. But last time I used Eclipse it was about five years ago, so things may have changed.
  - auto 9y ago
    I definitely meant that as "being based off Eclipse it comes with these advantages, but caveat emptor otherwise". Honestly I use Eclipse for all my Java dev at work, and compared with the OSX implementation of PGAdmin III, it's well worth the shortcomings.
wilwade 9y ago
I use Psequel (psequel.com) when I am out of the CLI and it works nicely and plays nicely with osx.
purerandomness 9y ago
If you're using IntelliJ IDEA or any of the other Jetbrains IDEs, there's an excellent and very polished database GUI built-in. It's also available as a standalone product (DataGrip)
tappleby 9y ago
I use Postico almost every day, great tool.
CCs 9y ago
NaviCat Premium worth the money
SnowingXIV 9y ago
Postico is fantastic. I’ve been part of a few discussions on github with new features they are adding in and the core team is super helpful and open to making the product better. I use it daily.
- always_good 9y ago
  Postico is nice but gives me anxiety. I don't like the metaphor of browser-style back/forward yet hoping the software remembers the state of a window when you go back to it.
chdsbd 9y ago
TablePlus supports Postgres/MySQL/Sql Server and others. It has a paid version which adds a few more features, but the free version works fine for me. https://tableplus.io/ https://tableplus.io/
nexus2045 9y ago
My money is on DBeaver (free). The killer feature is that you can have all the queries you're doing laid out on the same place and execute the one you want as pleased, and also selecting rows of results and generating an `INSERT` statement off them.
bmdavi3 9y ago
Other people have given actual answers, so I'll go ahead and give the non-answer of... use psql instead! Like Dimitri Fontaine says early in the Mastering PostgreSQL in Application Development book mentioned elsewhere in this thread, psql is really powerful. From the \d meta commands to inspect anything and everything in the database, to the variable substitution, nothing beats editing sql in your preferred editor and hitting \i my_query.sql in psql to run it. You can also nest additional \i my_other_query.sql commands inside the files you run with \i, which I've found really useful for repeatedly dropping / installing test tables / views, or setting up test data, before running the query I'm actually interested in. Take the time to customize it by adding a few lines to your .psqlrc file, like \x auto, and \timing and it becomes very usable very quickly. I used psql for a number of years, then joined a new company where DataGrip was the norm. I gave DataGrip an honest try to see what I might be missing from a GUI SQL client. After a year of using it exclusively, I slowly found myself migrating back to psql and can honestly say I don't miss anything. But it's also possible I just haven't tried the right GUI client yet. Anyway, I hope you find the PostgreSQL client that works for you!
- hestefisk 9y ago
  +1 on this one.
- mmckelvy 9y ago
  Concur. Once you get over the initial learning curve, psql is the weapon of choice.
- njharman 9y ago
  yes but pgcli, https://www.pgcli.com/ https://www.pgcli.com/
  - emmelaich 9y ago
    Nice. That tui looks similar to the gcloud alpha interactive cli.
d6de964 9y ago
Navicat is especially useful if you need to migrate from one database software to some other.
hestefisk 9y ago
pgAdmin III is pretty good. But imho one should start with raw psql before going to a GUI.
known 9y ago
https://www.aquafold.com/aquadatastudio https://www.aquafold.com/aquadatastudio is good
Angostura 9y ago
Depending on what kind of thing you want, I played with this a few years ago and really liked it: https://www.malcolmhardie.com/sqleditor/index.html https://www.malcolmhardie.com/sqleditor/index.html
ZeroClickOk 9y ago
Vote for SQL Operations Studio support: https://github.com/Microsoft/sqlopsstudio/issues/56 https://github.com/Microsoft/sqlopsstudio/issues/56

can anyone recommend a really good postgres GUI client? ive not found one yet for OSX, which is almost baffling

tonyarkles 9y ago

The guys at work seem to love DataGrip from the IntelliJ folks.

megaman22 9y ago

Datagrip? I almost prefer it over SSMS for Sql Server, and it looks like its postgres support is on par.

miketery 9y ago

Postico!

auto 9y ago

We moved from pgadmin to DBeaver at work and have been pretty satisfied. It's based off Eclipse, so benefits from the windowing/panes, and being able to use any eclipse plugins. My db usage world changed the day I got vim support and auto complete in my query editor.

omeid2 9y ago
Based off Eclipse should be considered a disadvantage. IMHO Eclipse on par with Electron in terms of being a CPU and Memory hog. But last time I used Eclipse it was about five years ago, so things may have changed.
- auto 9y ago
  I definitely meant that as "being based off Eclipse it comes with these advantages, but caveat emptor otherwise". Honestly I use Eclipse for all my Java dev at work, and compared with the OSX implementation of PGAdmin III, it's well worth the shortcomings.

wilwade 9y ago

I use Psequel (psequel.com) when I am out of the CLI and it works nicely and plays nicely with osx.

purerandomness 9y ago

If you're using IntelliJ IDEA or any of the other Jetbrains IDEs, there's an excellent and very polished database GUI built-in. It's also available as a standalone product (DataGrip)

tappleby 9y ago

I use Postico almost every day, great tool.

CCs 9y ago

NaviCat Premium worth the money

SnowingXIV 9y ago

Postico is fantastic. I’ve been part of a few discussions on github with new features they are adding in and the core team is super helpful and open to making the product better. I use it daily.

always_good 9y ago
Postico is nice but gives me anxiety. I don't like the metaphor of browser-style back/forward yet hoping the software remembers the state of a window when you go back to it.

chdsbd 9y ago

TablePlus supports Postgres/MySQL/Sql Server and others. It has a paid version which adds a few more features, but the free version works fine for me. https://tableplus.io/ https://tableplus.io/

nexus2045 9y ago

My money is on DBeaver (free). The killer feature is that you can have all the queries you're doing laid out on the same place and execute the one you want as pleased, and also selecting rows of results and generating an `INSERT` statement off them.

bmdavi3 9y ago

Other people have given actual answers, so I'll go ahead and give the non-answer of... use psql instead! Like Dimitri Fontaine says early in the Mastering PostgreSQL in Application Development book mentioned elsewhere in this thread, psql is really powerful. From the \d meta commands to inspect anything and everything in the database, to the variable substitution, nothing beats editing sql in your preferred editor and hitting \i my_query.sql in psql to run it. You can also nest additional \i my_other_query.sql commands inside the files you run with \i, which I've found really useful for repeatedly dropping / installing test tables / views, or setting up test data, before running the query I'm actually interested in. Take the time to customize it by adding a few lines to your .psqlrc file, like \x auto, and \timing and it becomes very usable very quickly. I used psql for a number of years, then joined a new company where DataGrip was the norm. I gave DataGrip an honest try to see what I might be missing from a GUI SQL client. After a year of using it exclusively, I slowly found myself migrating back to psql and can honestly say I don't miss anything. But it's also possible I just haven't tried the right GUI client yet. Anyway, I hope you find the PostgreSQL client that works for you!

hestefisk 9y ago
+1 on this one.
mmckelvy 9y ago
Concur. Once you get over the initial learning curve, psql is the weapon of choice.
njharman 9y ago
yes but pgcli, https://www.pgcli.com/ https://www.pgcli.com/
- emmelaich 9y ago
  Nice. That tui looks similar to the gcloud alpha interactive cli.

d6de964 9y ago

Navicat is especially useful if you need to migrate from one database software to some other.

hestefisk 9y ago

pgAdmin III is pretty good. But imho one should start with raw psql before going to a GUI.

known 9y ago

https://www.aquafold.com/aquadatastudio https://www.aquafold.com/aquadatastudio is good

Angostura 9y ago

Depending on what kind of thing you want, I played with this a few years ago and really liked it: https://www.malcolmhardie.com/sqleditor/index.html https://www.malcolmhardie.com/sqleditor/index.html

ZeroClickOk 9y ago

Vote for SQL Operations Studio support: https://github.com/Microsoft/sqlopsstudio/issues/56 https://github.com/Microsoft/sqlopsstudio/issues/56