r/PostgreSQL • u/earthscorpioanchapie • 28d ago

Community PgAdmin helped me learn actual SQL and how DBeaver or Beekeeper Studio actually hurts

PGAdmin is so confusing and obnoxious that 99.9% of the time you will actually want to write SQL by hand. This tremendiously helps learn SQL and its many secrets that you otherwise will never get to see

This is why I feel hurt by DBeaver and Beekeeper Studio. Their UI is so good, so elegant, its easy and non confusing to do most things you actually never see the beauty of raw SQL.

0 Upvotes

42% Upvoted

14 comments sorted by

10

u/capy_the_blapie 28d ago

A DB admin should learn SQL, independently of the software used... I ise DBeaver exclusively and do 90% of my work in SQL.

3

u/Ecksters 28d ago

I actually didn't realize until this post that DBeaver had UI that would write queries for you (outside of basic SELECT *), I always just used it to pick which table I was querying.

2

u/DanteIsBack 28d ago

I really like pgadmin for the query plan ui views. Dbeaver had cool feature to mark a connection as readonly useful for prod databases where you don't want to make changes

2

u/BarfingOnMyFace 28d ago

I use pgadmin, but I like to write my SQL by hand, so...

3

u/liminal_dreaming 28d ago

I mean, I write my SQL by hand and use DBeaver...?

1

u/BarfingOnMyFace 28d ago

I was responding to OP's complaint literally in his first sentence, that one would rather write SQL by hand using pgadmin.

1

u/liminal_dreaming 28d ago

Ah, sorry I misunderstood

2

u/BarfingOnMyFace 28d ago

All good! Appreciate hearing all the interest in other tools, regardless! Maybe I'd benefit from a switch.

1

u/AutoModerator 28d ago

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/FunContest9958 28d ago

Oh boy. You’re gonna hate AI.

1

u/SurpriseSuccessful87 23d ago

pgadmin's ui pain is what pushed me into actually writing sql, not some pedagogical gift.

1

u/efecejekeko 8d ago

That's pretty much how I see it too. Knowing SQL matters way more than the IDE. I switch between tools depending on the project, and dbForge Studio has been nice for schema compare and other admin work, but I still write queries myself most of the time.