Originally posted by uid313
View Post
Announcement
Collapse
No announcement yet.
PostgreSQL 12 Released As Newest Update To "World's Most Advanced Open-Source DB"
Collapse
X
-
-
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.
- Likes 1
Leave a comment:
-
Azure Data Studio also has a Postgres extension, but it doesn't see much development nowadays. The application itself is based on Code.
Leave a comment:
-
Originally posted by uid313 View Post
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.
Leave a comment:
-
Originally posted by cynic View Post
I fully agree about pgAdmin
What is SSMS?
Have you tried DBeaver? It's a nice pgAdmin alternative.
Oh this DBeaver looks rather nice.
Leave a comment:
-
Originally posted by uid313 View PostWhat is your favorite thing about PostgreSQL?
What is your favorite thing in another database that you miss in PostgreSQL?
The only thing I miss is a nice toolset a-la Oracle SQLDeveloper. pgAdmin is ugly af!Last edited by cynic; 05 October 2019, 01:24 AM.
- Likes 1
Leave a comment:
-
Originally posted by alcalde View PostI believe it's the only database JITing queries, etc.
- Likes 1
Leave a comment:
-
Originally posted by tildearrow View PostWorld's most advanced open-source database? How did they come to that conclusion?
I use MariaDB and it works really well (plus has broad support in regards to Spigot plugins).
PostgreSQL is still the only db with serializable snapshot isolation, it was the first database (open source or proprietary) to include k-nearest neighbor search, I believe it's the only database JITing queries, etc.
MariaDB is fine, but on the technical front it still lacks things like timezone support, parallel queries, partial indexes, writeable CTEs, arrays, range types, materialized views, user-defined types, etc. that PostgreSQL has and which make it the most advanced open-source database.
- Likes 3
Leave a comment:
-
Originally posted by uid313 View PostWhat is your favorite thing about PostgreSQL?
What is your favorite thing in another database that you miss in PostgreSQL?
At this point I don't think I miss anything from another database, other than of course it's not embeddable like SQLite.
Leave a comment:
Leave a comment: