Re: SQL/JSON in PostgreSQL

From: "Sven R(dot) Kunze" <srkunze(at)mail(dot)de>
To: Magnus Hagander <magnus(at)hagander(dot)net>, Peter van Hardenberg <pvh(at)pvh(dot)ca>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Oleg Bartunov <obartunov(at)gmail(dot)com>, David Steele <david(at)pgmasters(dot)net>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>, Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, Teodor Sigaev <teodor(at)postgrespro(dot)ru>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, andrew Dunstan <andrew(at)dunslane(dot)net>
Subject: Re: SQL/JSON in PostgreSQL
Date: 2017-03-09 18:12:07
Message-ID: 16a52989-e330-dcba-a82b-0306801cee42@mail.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 08.03.2017 20:52, Magnus Hagander wrote:
> On Wed, Mar 8, 2017 at 11:48 AM, Peter van Hardenberg <pvh(at)pvh(dot)ca
> <mailto:pvh(at)pvh(dot)ca>> wrote:
>
> Small point of order: YAML is not strictly a super-set of JSON.
>
> Editorializing slightly, I have not seen much interest in the
> world for YAML support though I'd be interested in evidence to the
> contrary.
>
>
> The world of configuration management seems to for some reason run off
> YAML, but that's the only places I've seen it recently (ansible,
> puppet etc).

SaltStack uses YAML for their tools, too. I personally can empathize
with them (as a user of configuration management) about this as writing
JSON would be nightmare with all the quoting, commas, curly braces etc.
But that's my own preference maybe.

(Btw. does "run off" mean like or avoid? At least my dictionaries tend
to the latter.)

> That said if we're introducing something new, it's usually better to
> copy from another format than to invite your own.

From my day-to-day work I can tell, the date(time) type is the only
missing piece of JSON to make it perfect for business applications
(besides, maybe, a "currency" type).

Regards,
Sven

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-03-09 18:14:20 Re: foreign partition DDL regression tests
Previous Message Robert Haas 2017-03-09 18:06:49 Re: updating parallel.sgml