From: | ShadowGhost <violin05082003(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Extension for PostgreSQL cast jsonb to hstore WIP |
Date: | 2024-04-02 11:07:47 |
Message-ID: | CAOsjGuOGk=j3B6tjTfBm4WSBtek8vkhdSK924RMFmW90nojuvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello all.
Recently, when working with the hstore and json formats, I came across the
fact that PostgreSQL has a cast of hstore to json, but there is no reverse
cast. I thought it might make it more difficult to work with these formats.
And I decided to make a cast json in the hstore. I used the built-in jsonb
structure to create it and may have introduced methods to increase
efficiency by 25% than converting the form jsonb->text->hstore. Which of
course is a good fact. I also wrote regression tests to check the
performance. I think this extension will improve the work with jsonb and
hstore in PostgreSQL.
If you've read this far, thank you for your interest, and I hope you enjoy
this extension!
---- Antoine
Attachment | Content-Type | Size |
---|---|---|
cast_jsonb_to_hstore.patch | application/x-patch | 9.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrey M. Borodin | 2024-04-02 11:35:28 | Re: Allow non-superuser to cancel superuser tasks. |
Previous Message | torikoshia | 2024-04-02 10:34:45 | Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) |