4 ms·

The biggest gripe I've had with Postgres (and I mention this elsewhere) is the lack of a decent GUI/IDE. But as Datagrip matures, the landscape can only get be

by wenc 9y ago

The biggest gripe I've had with Postgres (and I mention this elsewhere) is the lack of a decent GUI/IDE. But as Datagrip matures, the landscape can only get better. Datagrip is not free, but I'm willing to pay for something that works better than pgAdmin. There are some exciting things happening in the Postgres space. Outside of Citus for scaling out, TimescaleDB has a plugin that makes Postgres a strong contender in the time-series database space. Temporal joins have always been a problem with NoSQL time-series databases; otoh joins are what SQL databases have traditionally been optimized for. It'll be exciting to have a large-scale datastore where you can easily combine and recombine different time-series in a single query.

Dirlewanger 9y ago
For OSX: Postico (https://eggerapps.at/postico/ https://eggerapps.at/postico/). You have to pay, and it's no Sequel Pro, but it's leagues better than all the garbage free ones.
- iRobbery 9y ago
  Hmm i have been looking at this one before. Could you share some user experiences, like how often you get updates, and the start guide has a 'Connecting to a remote PostgreSQL server via SSH' section, without content yet, does tunnelling via SSH work nice/as expected?
  - newmanships 9y ago
    Not the op but connecting through SSH works great in my experience and is very straight forward in the UI. I feel like updates are pretty frequent as well. I also love that it saves all my queries unlike psequel.
  - enkrs 9y ago
    I can answer this, as I purchased Postico for our team just today (just out of gratitude really, as the free version is good enough) Tunnelling via SSH works great, but you do have to provide and save your ssh key password in Postico, because it does not use ssh-agent. Lots of great features and small updates here and there: it was updated with touch bar support quite quickly. A killer feature is Ctrl+P fuzzy search for table names in database. It's great for getting query data out of your db quickly or just browsing around. Ok to add the odd column here and there. However managing roles and permissions seems to be out of scope.
cvburgess 9y ago
If you haven't checked out Postico, it is hands-down the nicest database GUI I've worked with: https://eggerapps.at/postico/ https://eggerapps.at/postico/
sametmax 9y ago
PGadmin and DBeaver are nice, just in case you didn't tried them.
- nexus2045 9y ago
  +1 for DBeaver, tried most of the alternative clients already, love how you can easily copy and paste a generated INSERT statement based on a selected row, makes easy for "debug cycles".
- mynewtb 9y ago
  Pgadmin went downhill, the new version is borderline unusable.
  - Avernar 9y ago
    Yep. I'm still using pgadmin 3.
radnam 9y ago
Have you tried pycharm? It offers some nice things like auto-complete over SQL as well as your table schema.
- irrational 9y ago
  datagrip and pycharm are both made by JetBrains. Datagrip is probably the exact same thing built into pycharm, but as a standalone product.
  - noir_lord 9y ago
    Having use intellij ultimate and datagrip, pretty much, datagrip was a DBA orientated product built around the excellent database tools in intellij.
systems 9y ago
I tried Datagrip, and ... I cant say I am enthusiastic First thing to note, datagrip is a sql development ide, not a sql server admin tool, so it may lack some of the administration tool you might expect, like monitoring for example Even as an IDE, it seems lacking some basic notions, for example, there isnt really a meaningful way to have a SQL Project, you get a bunch of connection and query shells, but you dont really get a Project that encapsulate both, also there is not support for deployment Finally, I am getting the impression that Jetbrains, it getting too stretched, if you follow their bug list, its too big ... and many IDEs do not seem to get the same attention as others In conclusion, dont bet on Datagrip, its got a long way to go, there doesnt seem to be a good designer with interesting concepts behind it .. so it will just be at best a glorified sql mode
- bunderbunder 9y ago
  > I am getting the impression that Jetbrains, it getting too stretched, And how. With the rate at which they're churning out new projects and initiatives, I have to assume that they're either severely understaffed, or seeing the average tenure of their development team dropping like a stone with all those new hires. Maybe both at the same time.
bdemirkir 9y ago
Although it's expensive, Navicat (https://www.navicat.com https://www.navicat.com) provides polished experience for PostgreSQL.
da_chicken 9y ago
My workplace uses Aqua Data Studio (http://www.aquafold.com/aquadatastudio_features http://www.aquafold.com/aquadatastudio_features). It supports everything from Oracle, DB2 and SQL Server to PostgreSQL, MySQL, and SQLite. It even supports MongoDB. And it even has tools for importing from Excel spreadsheets directly. Pretty much if your RDBMS has a JDBC provider, it works with Aqua Data Studio. It's not free, and it's not cheap, but it's really quite nice.
malyk 9y ago
We use Sql Pro for Postgres. It's been great. https://macpostgresclient.com/ https://macpostgresclient.com/

by wenc 9y ago

Dirlewanger 9y ago

For OSX: Postico (https://eggerapps.at/postico/ https://eggerapps.at/postico/). You have to pay, and it's no Sequel Pro, but it's leagues better than all the garbage free ones.

iRobbery 9y ago
Hmm i have been looking at this one before. Could you share some user experiences, like how often you get updates, and the start guide has a 'Connecting to a remote PostgreSQL server via SSH' section, without content yet, does tunnelling via SSH work nice/as expected?
- newmanships 9y ago
  Not the op but connecting through SSH works great in my experience and is very straight forward in the UI. I feel like updates are pretty frequent as well. I also love that it saves all my queries unlike psequel.
- enkrs 9y ago
  I can answer this, as I purchased Postico for our team just today (just out of gratitude really, as the free version is good enough) Tunnelling via SSH works great, but you do have to provide and save your ssh key password in Postico, because it does not use ssh-agent. Lots of great features and small updates here and there: it was updated with touch bar support quite quickly. A killer feature is Ctrl+P fuzzy search for table names in database. It's great for getting query data out of your db quickly or just browsing around. Ok to add the odd column here and there. However managing roles and permissions seems to be out of scope.

cvburgess 9y ago

If you haven't checked out Postico, it is hands-down the nicest database GUI I've worked with: https://eggerapps.at/postico/ https://eggerapps.at/postico/

sametmax 9y ago

PGadmin and DBeaver are nice, just in case you didn't tried them.

nexus2045 9y ago
+1 for DBeaver, tried most of the alternative clients already, love how you can easily copy and paste a generated INSERT statement based on a selected row, makes easy for "debug cycles".
mynewtb 9y ago
Pgadmin went downhill, the new version is borderline unusable.
- Avernar 9y ago
  Yep. I'm still using pgadmin 3.

radnam 9y ago

Have you tried pycharm? It offers some nice things like auto-complete over SQL as well as your table schema.

irrational 9y ago
datagrip and pycharm are both made by JetBrains. Datagrip is probably the exact same thing built into pycharm, but as a standalone product.
- noir_lord 9y ago
  Having use intellij ultimate and datagrip, pretty much, datagrip was a DBA orientated product built around the excellent database tools in intellij.

systems 9y ago

I tried Datagrip, and ... I cant say I am enthusiastic First thing to note, datagrip is a sql development ide, not a sql server admin tool, so it may lack some of the administration tool you might expect, like monitoring for example Even as an IDE, it seems lacking some basic notions, for example, there isnt really a meaningful way to have a SQL Project, you get a bunch of connection and query shells, but you dont really get a Project that encapsulate both, also there is not support for deployment Finally, I am getting the impression that Jetbrains, it getting too stretched, if you follow their bug list, its too big ... and many IDEs do not seem to get the same attention as others In conclusion, dont bet on Datagrip, its got a long way to go, there doesnt seem to be a good designer with interesting concepts behind it .. so it will just be at best a glorified sql mode

bunderbunder 9y ago
> I am getting the impression that Jetbrains, it getting too stretched, And how. With the rate at which they're churning out new projects and initiatives, I have to assume that they're either severely understaffed, or seeing the average tenure of their development team dropping like a stone with all those new hires. Maybe both at the same time.

bdemirkir 9y ago

Although it's expensive, Navicat (https://www.navicat.com https://www.navicat.com) provides polished experience for PostgreSQL.

da_chicken 9y ago

My workplace uses Aqua Data Studio (http://www.aquafold.com/aquadatastudio_features http://www.aquafold.com/aquadatastudio_features). It supports everything from Oracle, DB2 and SQL Server to PostgreSQL, MySQL, and SQLite. It even supports MongoDB. And it even has tools for importing from Excel spreadsheets directly. Pretty much if your RDBMS has a JDBC provider, it works with Aqua Data Studio. It's not free, and it's not cheap, but it's really quite nice.

malyk 9y ago

We use Sql Pro for Postgres. It's been great. https://macpostgresclient.com/ https://macpostgresclient.com/