Re: jsonb and nested hstore

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Peter Geoghegan <pg(at)heroku(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: jsonb and nested hstore
Date: 2014-02-25 20:12:55
Message-ID: CA+Tgmoa+EqcR1NwgkfMBP7bsMC3TYM6HOOnJYZYFxhBAyUM_8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 25, 2014 at 1:54 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> On 02/25/2014 10:50 AM, Robert Haas wrote:
>> On Tue, Feb 25, 2014 at 1:45 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>>> On 02/25/2014 10:31 AM, Robert Haas wrote:
>>>> And I definitely don't
>>>> agree that our documentation should push people towards stuffing
>>>> everything in a JSON blob instead of using real column definitions.
>>>
>>> ????
>>>
>>> Where did you get this out of my doc patch?
>>
>> Way to quote what I said out of context.
>
> Way to put words in my mouth.
>
>> But to make a long story short, I get that from the fact that you want
>> to railroad everyone into using jsonb.
>
> That's called a "straw man argument", Robert.
>
> Me: We should recommend that people use jsonb unless they have a
> specific reason for using json.
>
> Merlin: We should present them side-by-side with a complex comparison.
>
> Robert: Josh wants to junk all relational data and use only jsonb!
>
> I mean, really, WTF?

OK, since what I said seems to have become distorted somewhere along
the line, allow me to rephrase:

I don't agree that jsonb should be preferred in all but a handful of
situations. Nor do I agree that partisanship belongs in our
documentation. Therefore, -1 for your proposal to recommend that, and
+1 for Merlin's proposal to present a comparison which fairly
illustrates the situations in which each will outperform the other.

Thanks,

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mohsen SM 2014-02-25 20:29:26 define type_transform to new user defined type
Previous Message Robert Haas 2014-02-25 20:06:50 Re: Unfortunate choice of short switch name in pgbench