4 ms·

I've found DBeaver [1] to be a good replacement after giving up with pgAdmin3 (I did love pgAdmin2, however). Datagrip is also fine if you're a Jetbrains user.

I've found DBeaver [1] to be a good replacement after giving up with pgAdmin3 (I did love pgAdmin2, however). Datagrip is also fine if you're a Jetbrains user. [1] https://dbeaver.io/ https://dbeaver.io/

GiorgioG 3y ago
+1 for DataGrip. It's not perfect, but it's miles ahead of anything else I've used in the recent past.
- tleilaxu 3y ago
  Datagrip’s main selling point for me is that it’s a familiar UI over most databases one uses day to day. I hop into the native apps for more complex, database specific features (GIS etc) but generally it’s perfect.
- j45 3y ago
  By chance has anyone who's used DataGrip also used Sequel Pro snd be able to comment?
pmontra 3y ago
Agreed. I do recommend DBeaver to customers that want a GUI for PostgreSQL. It's better at almost everything and it handles ssh tunnels well. Even certificates. I don't have any GUI client installed now. I ssh to servers and use psql there. I use psql locally and inside docker containers. I used pg-cli (?) years ago but I probably lost it during one of the various reinstalls (usually one for each Ubuntu LTS, I'm on Debian now) and I forgot about it.
j45 3y ago
DBeaver is nice, but Sequel Pro is hard to unsee.
laurensr 3y ago
I also found DBeaver to be a huge improvement over tools I used earlier. Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer https://github.com/Wisser/Jailer
williamdclt 3y ago
DBeaver is powerful and better than anything else I found (except maybe datagrip), but honestly its UX is terrible. It takes a million clicks to do basic things, the "export results" functionality is a maze, "rename connection" is a different functionality from "edit connection", ctrl+tab doesn't work, it's generally very noisy visually... I am using it on a daily basis and it's very powerful, but it shoves all the complexity at your face, it doesn't scale down. And it uses ~7% of my M1 CPU while sitting there unused, not even connected to any DB.

GiorgioG 3y ago

+1 for DataGrip. It's not perfect, but it's miles ahead of anything else I've used in the recent past.

tleilaxu 3y ago
Datagrip’s main selling point for me is that it’s a familiar UI over most databases one uses day to day. I hop into the native apps for more complex, database specific features (GIS etc) but generally it’s perfect.
j45 3y ago
By chance has anyone who's used DataGrip also used Sequel Pro snd be able to comment?

pmontra 3y ago

Agreed. I do recommend DBeaver to customers that want a GUI for PostgreSQL. It's better at almost everything and it handles ssh tunnels well. Even certificates. I don't have any GUI client installed now. I ssh to servers and use psql there. I use psql locally and inside docker containers. I used pg-cli (?) years ago but I probably lost it during one of the various reinstalls (usually one for each Ubuntu LTS, I'm on Debian now) and I forgot about it.

j45 3y ago

DBeaver is nice, but Sequel Pro is hard to unsee.

laurensr 3y ago

I also found DBeaver to be a huge improvement over tools I used earlier. Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer https://github.com/Wisser/Jailer

williamdclt 3y ago

DBeaver is powerful and better than anything else I found (except maybe datagrip), but honestly its UX is terrible. It takes a million clicks to do basic things, the "export results" functionality is a maze, "rename connection" is a different functionality from "edit connection", ctrl+tab doesn't work, it's generally very noisy visually... I am using it on a daily basis and it's very powerful, but it shoves all the complexity at your face, it doesn't scale down. And it uses ~7% of my M1 CPU while sitting there unused, not even connected to any DB.