Re: jsonb and nested hstore

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Hannu Krosing <hannu(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(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-26 20:45:06
Message-ID: 530E5252.9010003@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 02/26/2014 11:39 AM, Merlin Moncure wrote:
> On Wed, Feb 26, 2014 at 12:05 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> On 02/26/2014 09:57 AM, Merlin Moncure wrote:
>>> What is not going to be so clear for users (particularly without good
>>> supporting documentation) is how things break down in terms of usage
>>> between hstore and jsonb.
>>
>> Realistically? Once we get done with mapping the indexes and operators,
>> users who are used to Hstore1 use Hstore2, and everyone else uses jsonb.
>> jsonb is nothing other than a standardized syntax interface to hstore2,
>> and most users will choose the syntax similar to what they already know
>> over learning new stuff.
>
> The problem is that as of today, they are not done and AFAICT will not
> be for 9.4.

Well, we plan to push to have the indexes and operators available as an
extension by the time that 9.4 comes out.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2014-02-26 20:51:18 Re: extension_control_path
Previous Message Pavel Stehule 2014-02-26 20:18:30 Re: Adding a copying type for array elements