PostgreSQL 12 Released As Newest Update To "World's Most Advanced Open-Source DB"

[GrayShade]

I believe it's the only database JITing queries, etc.

SQL Server would beg to differ. But of course, that doesn't make PostgreSQL less great.

[cynic]

What is your favorite thing about PostgreSQL?

What is your favorite thing in another database that you miss in PostgreSQL?

My favourite feature is its reliability: I've been using PostgreSQL since version 7 and I've never missed a single row!
The only thing I miss is a nice toolset a-la Oracle SQLDeveloper. pgAdmin is ugly af!

[cynic]

I don't really like pgAdmin, especially the web version (SSMS is much better).

I fully agree about pgAdmin
What is SSMS?

Have you tried DBeaver? It's a nice pgAdmin alternative.

[uid313]

I fully agree about pgAdmin
What is SSMS?

Have you tried DBeaver? It's a nice pgAdmin alternative.

SMSS is SQL Server Management Studio, a software by Microsoft. Microsoft also have Azure Data Studio (previously named SQL Operations Studio).

Oh this DBeaver looks rather nice.

[pepoluan]

SMSS is SQL Server Management Studio, a software by Microsoft. Microsoft also have Azure Data Studio (previously named SQL Operations Studio).

Oh this DBeaver looks rather nice.

I've been using DBeaver for some time. You'll come to love it :-)

[GrayShade]

Azure Data Studio also has a Postgres extension, but it doesn't see much development nowadays. The application itself is based on Code.

[anarki2]

What I truly hate about postgresql is that if you use LDAP auth, you always have to pre-create the local roles on each and every instance for each and every LDAP user, before they can login. Quite ridiculous.

Limiting access based on LDAP group membership is also PITA and makes the implementation feel more like a PoC than an actual finished product.

[cynic]

SMSS is SQL Server Management Studio, a software by Microsoft. Microsoft also have Azure Data Studio (previously named SQL Operations Studio).

Oh this DBeaver looks rather nice.

There is also an handy flatpak package here: https://flathub.org/apps/details/io....eaverCommunity