qwertywert_ 7 days ago

Isn't PGAdmin good enough? Not hating, but I'm not a database guy either so just curious why create a VSCode extension for GUI stuff.

6
ketzo 7 days ago

The longer I work in engineering the fewer windows I want open on my screen

If this is “PGAdmin, but 50% worse, but it just lives as another tab in your editor instead of another application” that is genuinely a huge win for me

Probably that’s because my day-to-day isn’t actually database administration, it’s application development where I need to be able to work with a database from time to time — so the preservation of context, however marginal, is really nice.

deepsun 7 days ago

PgAdmin I think is more for working with data, I use Intellij DB editor mostly for writing complex SQL (with autocomplete, coloring, auto-formatting).

It also recognizes your regular programming code strings as SQL and can also autocomplete/highlight typos, but I don't use that, because we're using JOOQ that generates code stubs from live DB.

srameshc 7 days ago

I love PGAdmin. For me it works very well. And then there are other tools when I need to work with schema etc. I always feel PGAdmin is an open source product that the team is most actively working on, always keep releasing fixes and updates. I don't want it in my IDE yet.

brulard 7 days ago

Few years ago PGAdmin was almost universally hated, especially in HN discussions. I think it was mostly around 3 -> 4 "upgrade". I see the sentiment has changed, although for me PGAdmin's UI is still very clunky and I avoid it if I can.

lukebuehler 7 days ago

it's nice to have copilot in the db admin tool. I use pgadmin every day, and it's great, but lately i have found myself wishing to have AI support in writing certain queries.

drited 7 days ago

Can you setup entra authentication with PgAdmin? I'm more of a MS Sql person so I don't know, but if not the security improvement from this would be a huge improvement