Обсуждение: [HACKERS] Harmonization of json functions (SQLITE)

Поиск
Список
Период
Сортировка

[HACKERS] Harmonization of json functions (SQLITE)

От
Tobias Schönit
Дата:

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?

 

Regards,

Tobias

Re: [HACKERS] Harmonization of json functions (SQLITE)

От
Pavel Stehule
Дата:
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

 

Regards,

Tobias