Re: [HACKERS] SQL/JSON in PostgreSQL - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: [HACKERS] SQL/JSON in PostgreSQL
Date
Msg-id CAF4Au4zi9KDBqNwM241xy3Td4+fovYLkTgMokuKB54Wweh7FXQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] SQL/JSON in PostgreSQL  (David Steele <david@pgmasters.net>)
Responses Re: [HACKERS] SQL/JSON in PostgreSQL  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers


On Fri, Mar 3, 2017 at 11:49 PM, David Steele <david@pgmasters.net> wrote:
Hi Oleg,

On 2/28/17 2:55 PM, Pavel Stehule wrote:
> 2017-02-28 20:08 GMT+01:00 Oleg Bartunov <obartunov@gmail.com
>
>     Attached patch is an implementation of SQL/JSON data model from
>     SQL-2016 standard (ISO/IEC 9075-2:2016(E)), which was published
>     2016-12-15 and is available only for purchase from ISO web site
>     (https://www.iso.org/standard/63556.html
>     <https://www.iso.org/standard/63556.html>). Unfortunately I didn't
>     find any public sources of the standard or any preview documents,
>     but Oracle implementation of json support in 12c release 2 is very
>     close
>     (http://docs.oracle.com/database/122/ADJSN/json-in-oracle-database.htm
>     <http://docs.oracle.com/database/122/ADJSN/json-in-oracle-database.htm>),
>     also we used https://livesql.oracle.com/  to understand some details.

<...>

> This is last commitfest for current release cycle - are you sure, so is
> good idea to push all mentioned features?

Implementing standards is always a goal of the PostgreSQL community, but
this is a very large patch arriving very late in the release cycle with
no prior discussion.

We discussed this in Brussels, but I agree, the patch is rather big.
 

That the patch proposed follows a standard which will not be available
to the majority of reviewers is very worrisome, let alone the sheer
size.  While much of the code is new, I see many changes to core data
structures that could very easily be destabilizing.

I don't know when the standard will be publicly available.
 

I propose we move this patch to the 2017-07 CF so further development
and review can be done without haste and as the standard becomes more
accessible.

I wanted to have one more  good feature in 10 and let postgres be on par with other competitors.  SQL/JSON adds many interesting features and users will be dissapointed if we postpone it for next two years.   Let's wait for reviewers, probably they will find the patch is not very  intrusive. We have a plenty of time and we dedicate one full-time developer for this project.
 

Regards,
--
-David
david@pgmasters.net

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Transactions involving multiple postgres foreign servers
Next
From: Dilip Kumar
Date:
Subject: Re: [HACKERS] Proposal : Parallel Merge Join