Json(b) extension

Started by Dmitry Dolgovover 11 years ago3 messages
#1Dmitry Dolgov
9erthalion6@gmail.com

Hi all,

As you know, PostgreSQL introduced Json(b) support at the 9.4 version [1]http://obartunov.livejournal.com/177247.html,
and hstore v2.0 saved in separate repository [2]http://www.sigaev.ru/git/gitweb.cgi?p=hstore.git;a=summary. But although PostgreSQL
has this support at the core level, there are many useful functions, which
wasn't ported to Json(b) from hstore v2.0 and json. Here [3]https://gist.githubusercontent.com/erthalion/10890778/raw/f042872a92a1ab22ed7eb753fee2358b60d99d4a/hstore_to_jsonb.rst, I've made a
review of the missing Json(b) functions, which can be implemented. This
list can be updated in the future, of course. I want to implement the
missing functions in the form of extension (e.g. contrib/jsonx).

What do you think about this?

[1]: http://obartunov.livejournal.com/177247.html
[2]: http://www.sigaev.ru/git/gitweb.cgi?p=hstore.git;a=summary
[3]: https://gist.githubusercontent.com/erthalion/10890778/raw/f042872a92a1ab22ed7eb753fee2358b60d99d4a/hstore_to_jsonb.rst
https://gist.githubusercontent.com/erthalion/10890778/raw/f042872a92a1ab22ed7eb753fee2358b60d99d4a/hstore_to_jsonb.rst

#2Josh Berkus
josh@agliodbs.com
In reply to: Dmitry Dolgov (#1)
Re: Json(b) extension

On 04/24/2014 03:46 AM, Dmitry Dolgov wrote:

Hi all,

As you know, PostgreSQL introduced Json(b) support at the 9.4 version [1],
and hstore v2.0 saved in separate repository [2]. But although PostgreSQL
has this support at the core level, there are many useful functions, which
wasn't ported to Json(b) from hstore v2.0 and json. Here [3], I've made a
review of the missing Json(b) functions, which can be implemented. This
list can be updated in the future, of course. I want to implement the
missing functions in the form of extension (e.g. contrib/jsonx).

Thanks for making this list!

What do you think about this?

I think you should do it as a pgxn extension, for now. For it to be in
contrib/ or core, we'd need to argue extensively about the names of
operators and functions, which will take a while. If your goal is to
make this functionality available as soon as possible to users, an
external extension is the way to go.

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Dmitry Dolgov
9erthalion6@gmail.com
In reply to: Josh Berkus (#2)
Re: Json(b) extension

If your goal is to make this functionality available as soon as

possible to users, an external extension is the way to go.
No, my primary goal is to create the useful contrib extension and help to
the community =)
So, I also want to do it as a pgxn extension.

On 25 April 2014 00:11, Josh Berkus <josh@agliodbs.com> wrote:

Show quoted text

On 04/24/2014 03:46 AM, Dmitry Dolgov wrote:

Hi all,

As you know, PostgreSQL introduced Json(b) support at the 9.4 version

[1],

and hstore v2.0 saved in separate repository [2]. But although PostgreSQL
has this support at the core level, there are many useful functions,

which

wasn't ported to Json(b) from hstore v2.0 and json. Here [3], I've made a
review of the missing Json(b) functions, which can be implemented. This
list can be updated in the future, of course. I want to implement the
missing functions in the form of extension (e.g. contrib/jsonx).

Thanks for making this list!

What do you think about this?

I think you should do it as a pgxn extension, for now. For it to be in
contrib/ or core, we'd need to argue extensively about the names of
operators and functions, which will take a while. If your goal is to
make this functionality available as soon as possible to users, an
external extension is the way to go.

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers