21–30 of 32 posts
It's not a good UI, at least not on Mac. It's kind of clunky, confusing and slow. I don't know if there are many better free alternatives though.
psql and the meta commands like \d to view schema of a table, combined with your regular text editor and \i is IMO the greatest postgres UI. I spend a lot of time there though so I can see the appeal of a gui for someone who only occasionally looks around in the db.
1. UI remains klunky/ugly AF. Beyond aesthetics, you lost me when I can't copy/paste text from the UI e.g. error messages... the new connection screen (a user's first experience) are super klunky and don't get started about setting up an SSH tunnel... crazy error messages.
2. system stats requires an extension... that's not available in AWS RDS... wtf?
3. there is no 3 - pgadmin already lost me because these things are too easy to "get right" and I'm not going to give it more time when there's lots of other tools.
pgadmin team - sorry!!!
But for everything else, jetbrains / datagrip etc is just infinitely nicer to use.
I *love* postgresql but pgadmin is a big nope. I keep hoping someday... 1. UI remains klunky/ugly AF. Beyond aesthetics, you lost me when I can't copy/paste text from the UI e.g. error messages... the new connection screen (a user's first experience) are super klunky and don't get started about setting up an SSH tunnel... crazy error messages. 2. system stats requires an extension... that's not available in AWS RDS..…
It even seems nicer than some other software in some aspects - it can actually be surprisingly and refreshingly fast (once loaded) and interactions I don't expect to work often enough actually do (like editing displayed values).
Sure, it could be more intuitive. But it's not all that bad.
That said, I haven't found the one RDBMS tool that I'd absolutely love, along the lines of the "aha" moment I got when working on large Java codebases in IntelliJ IDEA, or using VS Code for throwing something smaller together quickly, or even using GitKraken for making Git palatable, or MobaXTerm for SSH and RDP/VNC/SFTP sessions.
pgAdmin and MySQL Workbench are both okay, but not amazing (even when autocomplete isn't broken in either). DataGrip by JetBrains somehow feels a bit clunky to me. DbVis is perhaps the best one I've seen for visualization, but that's all it does well. There's also Open Jail which is great for exploring datasets... but there's no tool that does pretty much everything in a way that is satisfying and lets me fly through tasks.
I'm still glad that there are options, though. DataGrip supporting lots of different RDBMSes is already a good thing, as are the more specialized options like pgAdmin.
It's not a good UI, at least not on Mac. It's kind of clunky, confusing and slow. I don't know if there are many better free alternatives though.
psql and the meta commands like \d to view schema of a table, combined with your regular text editor and \i is IMO the greatest postgres UI. I spend a lot of time there though so I can see the appeal of a gui for someone who only occasionally looks around in the db.
Earlier quoted context omitted.
psql and the meta commands like \d to view schema of a table, combined with your regular text editor and \i is IMO the greatest postgres UI. I spend a lot of time there though so I can see the appeal of a gui for someone who only occasionally looks around in the db.
psql is good but how do you manage long multi line queries and saved collections of queries to reuse? or connections to multiple databases?
Earlier quoted context omitted.
Could you be more specific - what's crap about it? I found it awesome that I can host it on a server similar to phpmyadmin and give out access to my staff. And the app itself is very good IMHO. The developers have full admin access to their computers, but not the DBAs and the Business Analysts. They can't install anything on their computers. So giving them an URL to work with was a huge win. If you want something lik…
Capabilities are great, but it's not great as a desktop app. I'm constantly fighting against the UI -- the behavior of tabs for instance.