PostgreSQL 11 RC1 Released Ahead Of Stable Release Next Week

[phoronix]

Phoronix: PostgreSQL 11 RC1 Released Ahead Of Stable Release Next Week

One week from today will hopefully mark the release of the PostgreSQL 11 stable database server release...

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

[uid313]

It doesn't support SQL/JSON, only Oracle Database support that standard.
However it does support JSON through its own non-standard implementation.

Also it doesn't support data masking, which Microsoft SQL Server 2016 does, which is good for GDPR.

I wonder if there will ever be a data language to replace SQL.
SQL is very old, but encompasses so much. It is data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML).
SQL is a bit like Assembly, then you have a ORM on top of it.

I just wish PostgreSQL had a better CLI modeled after tools such as dotnet or apt-get, where everything runs from a proxy program which executes subprograms that are all prefixed with the same name.

[dkasak]

Ugh. You posted exactly the same thing in response to a previous Postgres article. Pretty lame. The answers haven't changed.

SQL/JSON is not a standard.
Data masking - postgres supports per-column permissions.
Language to replace SQL - why? It works very well for what it's intended for. Learn it.
A CLI "modeled after tools such as dotnot or apt-get" ... ah ... wtf?

[Vistaus]

Ugh. You posted exactly the same thing in response to a previous Postgres article. Pretty lame. The answers haven't changed.

Don't bother with him, he always posts the exact same things.