[JamesMcMinn]

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/

[GiorgioG]

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

[tleilaxu]

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]

By chance has anyone who's used DataGrip also used Sequel Pro snd be able to comment?

[pmontra]

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.

[williamdclt]

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.

[laurensr]

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

[j45]

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