[throwaway62012]

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 like the old pgAdmin, try DBeaver.

[jug]

Yes, all my love to DBeaver! I achieve so much better performance and productivity in that one over things like pgAdmin 4 and SQL Server Management Studio. It's a gem. <3

[ubercore]

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.

[stefs]

i have the same issue. it doesn't feel natural.

[mattashii]

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.

[WirelessGigabit]

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; ...

[mattashii]

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.

[dsego]

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.

[throwaway62012]

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

[TylerE]

Honestly these days I just use IntelliJ for everything. It’s DB module is really good.