Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] Harmonization of json functions (SQLITE) - Mailing list pgsql-hackers

From Tobias Schönit
Subject [HACKERS] Harmonization of json functions (SQLITE)
Date
Msg-id CA++QQJv2grUXA0tok7mMp=PdJGPDa8Vaz60bbsQtkSFS89JSyw@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] Harmonization of json functions (SQLITE)  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view

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

pgsql-hackers by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: [HACKERS] Index corruption with CREATE INDEX CONCURRENTLY
Next
From: Thomas Munro
Date:
Subject: Re: [HACKERS] Non-deterministic behavior with floating point inparallel mode