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

[jacob]

What is your favorite thing about PostgreSQL?

Its documentation.

[tildearrow]

It's written in C, not C++ like MySQL/MariaDB, not sure if this is or can be necessarily a bad or a good thing.

It is a good and a bad thing at the same time.

C may be faster than C++, but C++ is safer and easier to maintain.

[tildearrow]

World'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).

[boxie]

What is your favorite thing about PostgreSQL?

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

First up - Good Questions!

I don't have any one "favourite" thing about postgres - it's more a "it just works really and there are answers to all the questions I ask" situation.

The things I miss in comparison to MySQL are the ease of use things. e.g. MySQL (at least had when I was last using it) really nice official GUI tools for design and dev. MySQL is also a little more lax on what you can do (one example: in MySQL you can select columns not in a group by and you can abuse that quite nicely - Postgres makes you use windowing functions and other bits which makes that more complex).

[GrayShade]

What is your favorite thing about PostgreSQL?

PostGIS is awesome, and it has pretty much every feature you might want, from JSON and XML to full-text search. It had window functions and hash and merge joins long before MySQL, but that's probably moot now.

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

I missed Inline CTEs (they've been added in 12) and included columns (added in 11) from SQL Server. Automatically clustered indexes are not implemented yet. I don't really like pgAdmin, especially the web version (SSMS is much better). There are some performance cliffs when using functions, and the PL/pgSQL syntax is kinda' meh. It could probably do with better OS integration like threads and pread/write support (EDIT: that's also in 12).

[onicsis]

What is your favorite thing about PostgreSQL?

It's written in C, not C++ like MySQL/MariaDB, not sure if this is or can be necessarily a bad or a good thing.

[uid313]

What is your favorite thing about PostgreSQL?

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

[phoronix]

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

As was anticipated, PostgreSQL 12.0 is now officially available...

http://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-12-Released