Re: [PATCH] Generalized JSON output functions

From: Ryan Pedela <rpedela(at)datalanche(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Generalized JSON output functions
Date: 2015-05-23 01:03:47
Message-ID: CACu89FTtTuV2tHH=0f723pA-tDwwvfKPKMBc71dGXp3Nzpa5TA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, May 22, 2015 at 10:51 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

> On Fri, May 22, 2015 at 9:43 AM, Alvaro Herrera
> <alvherre(at)2ndquadrant(dot)com> wrote:
> > Andrew Dunstan wrote:
> >>
> >> On 05/20/2015 09:16 AM, Shulgin, Oleksandr wrote:
> >
> >> >Attached is a patch against master to generalize the JSON-producing
> >> >functions in utils/adt/json.c and to provide a set of callbacks which
> can
> >> >be overridden the same way that is already provided for *parsing* JSON.
> >
> >> I'm not necessarily opposed to this, but it sure seems like a lot of
> >> changes, and moderately invasive ones, to support something that could
> be
> >> done, at the cost of reparsing, with a simple loadable extension that I
> >> could create in a few hours of programming.
> >
> > But this seems like a pretty reasonable change to make, no? Doesn't the
> > total amount of code decrease after this patch? JSON stuff is pretty
> > new so some refactoring and generalization of what we have is to be
> > expected.
>
> Yeah. Also, there have been a few previous gripes about this, for
> example,
> http://www.postgresql.org/message-id/CAHbVmPzS+sVR+y-UgxjRq+XW4dqteVL-cOzc69zFFwmxjcKCxg@mail.gmail.com
> .
> As noted, I definitely prefer 'space free' by default for efficiency
> reasons, but standardizing the output has definitely got to be a
> reasonable goal.
>

Every JSON implementation I have ever used defaults to the minified version
of JSON (no whitespace) when printed.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2015-05-23 02:22:14 jsonb_set: update or upsert default?
Previous Message Andres Freund 2015-05-23 00:20:55 Re: Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.