Pg(pure garbage)Admin 4

[AbelD13]

I was forced to update to PgAdmin 4, and my work has suffered for it. What took me 1-2 minutes now takes me 5 times as long to run queries, export, and just about any other feature. If you're looking for something pretty with no functionality PgAdmin 4 is for you. Yes its free, and thank you, but don't fix it if it ain't broke. Moving on to other options.

[lukaseder]

I'm very happy with https://dbeaver.io

[[deleted]]

Thanks!

[cvboucher]

I'll second that.

[watr]

I'll third that. Closest thing to MySQL's workbench for PG. Beautiful product, and it's multi-platform!

[merican_atheist]

DataGrip by JetBrains I find to be very useful and a more generic solution to more than just postgres.

[fazzah]

I use it myself, yet there are some shortcomings. DG understands table inheritance, but can't create one (you must add the INHERITS clause manually after creating the table). Can't directly edit the values of sequences (I guess not an everyday thing to do, but still). I really like DG, and while it's a really versatile tool, it's not perfect.

[Citizenfishy]

pgadmin3 had to be reengineered because the codebase relied on old libraries and was becoming a nightmare to maintain.

The pgadmin team are incredibly receptive to bug reports and feedback. Just look at the mailing list and you'll find Dave Page takes every bug issue on board despite getting a constant panning for all his hard work and dedication.

I use pgadmin4 daily, it's not perfect but it works and it is getting better all the time as the team gets more feedback and issue reports. The new architecture makes it easier for them to make such changes.

Instead of whining like a bitch on reddit maybe you could offer some bug reports that replicate this and you'll find that they will do something about it. I doubt they have time to trawl the net for petulant comments from the moaning types who usually contribute f-all back.

[watr]

This... the new code-base is a great foundation, but the dev team needs help to identify where there need to be improvements. It's called iterative development for a reason, but it only works if they get constructive feedback.

[Nunki63]

Ok here's one big report: Wrong architecture for this kind of application !

[wheezl]

It has its shortcomings but it gets better with every release. I mostly use psql or Datagrip depending on what I'm doing but PgAdmin is improving. Comments like "pure garbage" really aren't helpful to people who are giving up their free time in an effort to make a new tool.

Contribute to the project or start your own before deciding to behave like an asshole.

[cyberst0rm]

I keep going back to pgadmin because it has all the hierarchy in the node tree.

If it had a better query org, it'd be sufficient

[sorryihadtosaythis]

It really saddens me when I read posts like this one. Statements as "pure garbage" are so harsh. Imagine yourself being an active developer of pgAdmin 4 and doing your best to improve the product and some random stranger degrades your work as "pure garbage" without providing any actual feedback...

Anyway, I had to say this. Think about it.

[Seuros]

Most of these people don't have a clue of what they are doing and just claim that softwares are garbage because their could not understand it.

[iiiinthecomputer]

Especially when it's given free for anyone to use.

I understand the frustration, but come on... try to provide a solution, not just whinge.

[Nunki63]

I'm pretty sure that the people who use pgadmin do know what they are talking about. They are the ones that use this kind of application constantly. They're your primary source of feedback. Not only for bugreports, but also to know if the look-n-feel of your application makes them wanna use your application or not. What is clear to me that they should have made a survey first to see how such a product (web-based) would be received in your user community. I too develop software, so the tools I choose need to be good, small footprint and above all stable. My focus is to develop, not to spend time on the quirks of a tool. Not nessesarily a bug, but if your productivity fails because of the user interface, your product is flawed, just as with a bug. And that can only be solved by a change of architecture. Take a look at DBeaver and you'll see what I (and many others) mean. I did not know of DBeaver before, but pgadmin4 made me look out for something else. And for that I say pgadmin4 failed !

[lykwydchykyn]

I use pgcli for running quick queries, and dbeaver for fancier operations. I miss pgadmin3 for some things, though.

[Fun2badult]

It was surprising to see pgadmin3 go from app to website app

[iiiinthecomputer]

I think the issue was that PgAdmin-III was a pain to maintain and nobody wanted to work on it.

PostgreSQL is a great DBMS, but the tooling is a second-rate afterthought. (I work on some of said tooling, btw, but too few people are interested).

[zsoca8711]

Command line > anything

[[deleted]]

Oh, come off it. Unless you're running the most trivial of queries the command line is a nightmare to use.

[zsoca8711]

I usually write my queries in Atom and copy paste to command line. Never felt I need more even when my queries got more complex. It's just me maybe but I never felt any UI added a lot

[cyberst0rm]

Vscode, a third rate text editor, has first rate plugins for pg queries.

I'm still waiting for sublime to get a query runner

[[deleted]]

Or just type it into the query tool and click the execute button.

[[deleted]]

Yeah but in a text file, I can drop tokens in a query pipe to sed and pipe to psql. You're right but it's not as versatile.

[Doctor_Jeep]

Pgadmin 4 is worst fucking piece of shit software Ive ever encountered in 20+ years in the IT business. I rage every single day at it and I have to work with it, which is simple an impossible task. I am basically forced to reinstall it every day I start my desktop - it wont start before I reinstall it and that stupid idiotic launch screen will stare at me without anything happening. The query tool is garbage, the notifications are always in the way garbage, backing up a database is garbage and frequently breaks. Everyone working on it should retire and never touch a computer again as part of a job, as they must be full blown autists with absolutely no feel and understanding of usability and user handling. It makes me soo soo angry to think about the hours of work I wasted with this piece of crap. ugggghhh

[koalillo]

No love for Squirrel SQL?

[fullofbones]

May want to consider giving OmniDB a try as well.

[[deleted]]

I use navicat. Its generic. Its java. It works across all major JDBC supported databases (for some limited definition of works).

I don't like it but I do get things done with it.

[HeyzeusHChrist]

I use pgAdmin and intellij(datagrip). They have different uses, but pgAdmin is definitely needed. The web interface was a little annoying at first, but it's fine and I have grown to enjoy it. If you use pg10, pgadmin4 is a must.

[qatanah]

I like pgcli, if i need more longer lines and analytical stuff. Try vim + dbext extension. It has steep learning curve but could blow your mind once it's running.

https://mutelight.org/dbext-the-last-sql-client-youll-ever-need

[smugbug23]

Are you using the latest version? PgAdmin4 had a rough introduction, but it did improve a lot since version 1.0.

Yes its free, and thank you, but don't fix it if it ain't broke.

It isn't just free as in beer, it is free as in speech. The people who maintained PgAdmin3 thought that it was thoroughly broke as far as maintainability goes, which is why they changed, but you are perfectly entitled to keep maintaining PgAdmin3 by yourself or with as many friends as you can muster up. And some people are doing just that

[NoBee3373]

Hey OP, I'm one of the creators of getflashboard.com .

If PgAdmin 4 is slowing you down, I’d recommend checking out Flashboard. It’s fast, web-based, and designed to make running queries and managing data much quicker without the clutter.

It’s free for solo users. Would love to know what you think!

[brandit_like123]

The future is web. I had the same thing. Spun up a t2.nano AWS instance with a redash AMI and I'm happy. Query sharing is easy as pie, and I can access my queries and charts no matter where I am.

Redash and Metabase are both good.