postgres and pgadmin ... 4... why?

cytg111

Lifer
Mar 17, 2008
25,457
14,966
136
So, with version 10 pgadmin3 is finally giving up on me and I am moving to pgadmin4 ... now I remember why I did what I could to stay with 3.
.... Starting server ? What the ... is going on? Oh yea ... webserver, cause, my dbadmin needs ... needs to go through a browser. Whyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy is this a good idea? There must be some rationale as to whyyyyyyyyyyyyyyyyyyyyyyy this is a super good idea? I just cant come up with any ... Someone else can?
 
  • Like
Reactions: beginner99
Feb 25, 2011
16,990
1,620
126
It's easier to write a single web interface than different thick clients for different platforms/targets. Windows API changes will break your app faster than browsers are likely to drop support for legacy technologies, and installation and configuration for your users is also simplified greatly. (read: eliminated.)

You say, "but Dave, why would a DBA have trouble installing and configuring a thick client? That's crazy-easy." to which I say, "They don't think it be like it is, but it do."
 
  • Like
Reactions: cytg111

cytg111

Lifer
Mar 17, 2008
25,457
14,966
136
I recalled that I had invested in a all-in jetbrain license.. I am rocking DataGrip now .. I am over this issue, thanks anyway :).
 

piokos

Senior member
Nov 2, 2018
554
206
86
Yeah it's a good example of what happens when you let young hipsters kiddies that play with node.js and other crap do real work.
Actually, it's a common problem with community projects. The team behind PostgreSQL is mostly database-oriented. They don't have experience and manpower to design good GUI.
E.g. there's not a single graphic / UX designer mentioned here:
https://www.postgresql.org/community/contributors/
pgAdmin is (and has always been) just a simple add-on for administration purposes - because some features (new or rarely used) may not be supported by a 3rd party solution. And because most competitors offer dedicated GUIs. :p

It's actually an good thing pgAdmin 4 is browser-based. It means easier access from any PC (for quick, ad-hoc maintenance tasks).
Sure, it's less usable as a general tool for working with the data, but it's never been a great choice anyway, i.e. most people use a different tool.