Harmonization of json functions (SQLITE)

Hi

2017-02-03 8:52 GMT+01:00 Tobias Schönit <tobias.schoenit@gmail.com>:

Hello,

I just saw on hackernews the announcement that sqlite includes a json
extension.

The proposed functions are really well documented and easy to apply and I
was wondering if postgres could extend their json functions to be similar
to those.

https://www.sqlite.org/json1.html

Some functions are similar (json_each) while others are missing in
postgresql (json_set)

Maybe it would also be a viable path to create a plugin and reuse some oft
he code from the sqlite community?

I am not sure, if PostgreSQL upstream code can reuse SQLite code.

What I know the PostgreSQL target is SQL/JSON syntax - but SQLite
compatible JSON can be nice extension (maybe some more bigger - SQLitefce -
like Orafce)

Some work can be shared - SQLite has uses JSONPath that is required by
SQL/JSON

Regards

Pavel