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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] Harmonization of json functions (SQLITE)
Дата
Msg-id CAFj8pRB+zb9tNw9xO1h53rS9po2VV1QA2+-0AzC88K5q9Jdk-w@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] Harmonization of json functions (SQLITE)  (Tobias Schönit <tobias.schoenit@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [HACKERS] proposal: session server side variables
Следующее
От: Erik Rijkers
Дата:
Сообщение: Re: \if, \elseif, \else, \endif (was Re: [HACKERS] PSQL commands:\quit_if, \quit_unless)