I've found Datagrip to be far and away the most impressive universal database tool. I feel like I've tried them all, and they all have a quality of having been developed by database people, rather than IDE designers. The depth of capability, extensibility, pace of improvement--I'm a very happy customer.
I don't want to poop on open source, but pgadmin and dbeaver and not even close to playing in the same league.
I work in Oracle and Datagrip saved my sanity.
Are there any features in datagrip in particular that you like that aren't in dbeaver?
I used DBeaver (community edition) before Datagrip and I would have to give the nod to datagrip overall. I wouldn't have even tried it if I did not have the etbrains all product pack. DBeaver is great, don't get me wrong, but Datagrip just seems a lot more polished overall and the settings and the UI just seem more intuitive to me.
More streamlined UI. I find the graph viewer to display some things nicer, like coloring tables, bringing in related tables. Slightly better introspection and code formatting. Easier refactoring capabilities. Easier to get IdeaVim working then whatever Ecplise plugin is needed in DBeaver.
In my experience, DataGrip has been easier to get up and running out of the box and bringing the big IDE guns than DBeaver but DBeaver also does done this really well. For example I have never been able to setup DG with Access but DBeaver works pretty good out of the box with that garbage. Also it's free.
Both are solid
I'd love to try datagrip, what are some advantages over pgadmin or others?
Many people love Datagrip because it's got the polish and style of Jetbrains' other products. Others hate it and much prefer the more classic designs of DBeaver or the browser UI of PGAdmin.
I think it's worth downloading the 30 day trial and giving it a quick whirl. The people who dislike it seem to get hesitant quite quickly, so I doubt you'd need more than a day to decide if it's for you or not. There are all kinds of cool and fancy plugins you can set up, but I wouldn't bother with that if you decide the UX just isn't for you.
It supports quite literally every database I've thrown at it, which is pretty nice.
The way it support projects is also rather useful to me as a developer. Most SQL tools seem to be focused on being an interface first and maybe having a few SQL files open second, but Datagrip's basis as an IDE makes it very easy to maintain collections of scripts (version migrations etc).
That said, I'm not sure if the 99 bucks (a year if you want updates, though you get a perpetual license for the current version) is worth it. I use it because it's part of Jetbrains' all products pack, which I paid to use other IDEs, essentially giving me Datagrip for free. If you're not already a Jetbrains customer you could definitely give it a go, but the value per dollar it provides is very different.
With Datagrip, you get all the niceties of a JetBrains IDE: massive customization, numerous plugins (e.g. IdeaVim, GitHub Copilot), lots of documentation. But you also get support for countless Db engines - I haven't seen anything yet which wasn't supported. The only one that was half-baked was Redis support, but it's not exactly a Db, either. Most importantly, it's that the UI doesn't feel clunky, unlike with PgAdmin. Everything feels streamlined and 1 or 2 clicks away, at most.
I doubt any new hotness could tear me away from Datagrip. I've used loads of database admin UIs over the years, and Datagrip is by far the most impressive.
This is going to be subjective, but the interface is better, especially if you're used to other jetbrain products. I haven't used pgAdmin for a while, but I remember the autocomplete being clunky to use and, quite frankly, quite bad.
My company had some leftover Datagrip licences, and it felt like moving from notepad to an IDE. I haven't looked back since.