Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PgAdmin 4 v8.0

pgadmin.org

Post reply on HN
Print view View original

11–20 of 32 posts

Re: PgAdmin 4 v8.0

#11

Post by throwaway62012 »

dsego wrote: post #9
throwaway62012 wrote: post #7

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…

Can't you also give granular access to the DB itself and people connect via the GUI app? I don't see how it's different.

That's what I'm doing, but my users can't install desktop apps.

Re: PgAdmin 4 v8.0

#13

Post by mattashii »

throwaway62012 wrote: post #7
TylerE wrote: post #5

Earlier quoted context omitted.

That was when it went from being a decent gui app to a craptacular web app, right? Or was that v3?

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…

I haven't used v4 because last time I wanted to use an UI for managing the DB:

- It didn't have 'connect with psql' that v3 did

- It added significant overhead and connections to the DB server

- It didn't have proper windowing support (e.g. panels could easily get lost)

- Shutting it down regularly required going into process manager, rather than closing the window.

These are the issues I can remember, but I've never really looked at it since then, in '20 or '21. Maybe those issues were fixed. Probably not.

Re: PgAdmin 4 v8.0

#14

Post by crubier »

rc_dock is amazing, nice to see it being used more in the wild. I dislike it's ties with antd and other css peculiarities, but it's very solid

Re: PgAdmin 4 v8.0

#15

Post by WirelessGigabit »

mattashii wrote: post #13
throwaway62012 wrote: post #7

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…

I haven't used v4 because last time I wanted to use an UI for managing the DB: - It didn't have 'connect with psql' that v3 did - It added significant overhead and connections to the DB server - It didn't have proper windowing support (e.g. panels could easily get lost) - Shutting it down regularly required going into process manager, rather than closing the window. These are the issues I can remember, but I've never…

You can now get a PSQL prompt in pgAdmin:

https://www.pgadmin.org/docs/pgadmin4/8.0/psql_tool.html

> ... Administrators can enable the use of the PSQL tool in the pgAdmin configuration by setting the ENABLE_PSQL option to True; ...

Re: PgAdmin 4 v8.0

#16

Post by qd011 »

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.

Re: PgAdmin 4 v8.0

#17

Post by mattashii »

WirelessGigabit wrote: post #15
mattashii wrote: post #13

Earlier quoted context omitted.

I haven't used v4 because last time I wanted to use an UI for managing the DB: - It didn't have 'connect with psql' that v3 did - It added significant overhead and connections to the DB server - It didn't have proper windowing support (e.g. panels could easily get lost) - Shutting it down regularly required going into process manager, rather than closing the window. These are the issues I can remember, but I've never…

You can now get a PSQL prompt in pgAdmin: https://www.pgadmin.org/docs/pgadmin4/8.0/psql_tool.html > ... Administrators can enable the use of the PSQL tool in the pgAdmin configuration by setting the ENABLE_PSQL option to True; ...

I'll note that that's not at all equivalent to v3's 'connect with psql'. v3 popped open a terminal with psql for the user in a new window (thus giving an equivalent experience to 'normal' use of psql, with the user's configured terminal settings etc.), while v4 only forwards the output of a virtual terminal to their web app (thus requiring you to keep a window open, keeping v4's server running, etc.).

I can understand why they did that (with the whole 'web first' shtick), but for me it does not provide the same functionality and is thus essentially useless.

Re: PgAdmin 4 v8.0

#18

Post by renatovico »

pgadmin 4 is a shit show of what happens when does not have a properly research what you users wants, pgadmin 3 works fine, is consistent.

first start fight with install a local daemon always consuming my machine, after firewall rules issues, only for open the app.

after this is not native app, i can t simple copy and paste to excel or another app

i tried in mac, linux, windows, and all suffers this problems.

result of this, i m simple go back to psql pure and if need some fancy navigation datagrip, and forget the existence of pgadmin, it is very sad because was really care about pgadmin v3 and use for my daily driver *(

Re: PgAdmin 4 v8.0

#20

Post by efxhoy »

qd011 wrote: post #16

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.

Post reply on HN