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.
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. |