Re: jsonb and nested hstore

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Christophe Pettus <xof(at)thebuild(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: jsonb and nested hstore
Date: 2014-03-05 19:32:12
Message-ID: 20140305193212.GC15259@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Mar 5, 2014 at 10:59:37AM -0800, Peter Geoghegan wrote:
> On Wed, Mar 5, 2014 at 8:30 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> >> Just out of curiosity, exactly what features are missing from jsonb
> >> today that are available with hstore? How long would it take to
> >> copy-and-paste all that code, if someone were to decide to do the
> >> work instead of argue about it?
> >
> > I believe the main thing is the opclasses.
>
> Yes, that's right. A large volume of code currently proposed for
> hstore2 is much less valuable than those operators sufficient to
> implement the hstore2 opclasses. If you assume that hstore will become
> a legacy extension that we won't add anything to (including everything
> proposed in any patch posted to this thread), and jsonb will go in
> core (which is of course more or less just hstore2 with a few json
> extras), the amount of code redundantly shared between core and an
> unchanged hstore turns out to not be that bad. I hope to have a
> precise answer to just how bad soon.

So, now knowing that hstore2 is just hierarchical hstore using the same
hstore type name, you are saying that we are keeping the
non-hierarchical code in contrib, and the rest goes into core --- that
makes sense, and from a code maintenance perspective, I like that the
non-hierarchical hstore code is not going in core.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2014-03-05 19:46:32 Re: GSoC propostal - "CREATE SCHEMA ... LIKE ..."
Previous Message Alvaro Herrera 2014-03-05 19:24:22 Re: [BUG FIX] Compare returned value by socket() against PGINVALID_SOCKET instead of < 0