MIME-Version: 1.0
In-Reply-To: 
 <CA+W24BXXXQLT_Yak36DHQeOi9huEnyZX8EzvC5zU_OeVP7RU-g@mail.gmail.com>
References: 
 <CA+W24BU2=w9DSH9Uq6eSiEniQN7SKmrRGSYLpVVPZrGPc2JcZw@mail.gmail.com>
 <CAJexoSJqBGfWjwOSF0nn36qs9vbkpNQtPs-BG5=KFfmknLgWNQ@mail.gmail.com>
 <CA+W24BXXXQLT_Yak36DHQeOi9huEnyZX8EzvC5zU_OeVP7RU-g@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 27 Aug 2024 09:17:29 -0700
Message-ID: 
 <CAKFQuwbtZC7cUKMmGy51PYCvAQM4jSK2s1TZwb888H=4ayFHXQ@mail.gmail.com>
Subject: object mapping for json/jsonb columns
To: Jan Bernitt <jaanbernitt@gmail.com>
Cc: Steve Midgley <science@misuse.org>,
	"pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000a8b140620ac947f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbtZC7cUKMmGy51PYCvAQM4jSK2s1TZwb888H%3D4ayFHXQ%40mail.gmail.com>
Precedence: bulk

--0000000000000a8b140620ac947f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tuesday, August 27, 2024, Jan Bernitt <jaanbernitt@gmail.com> wrote:

>
> So if nothing like this exists in postgreSQL I highly suggest starting to
> design JSON(B) functions that offer this flexibility :)
>

PostgreSQL is both extensible and open source.  I highly suggest this seems
like a perfect place for some enterprising people to leverage those aspects
to improve things instead of burdening the core developers with more work.
Given that pluggable procedural languages already have this kind of tooling
I=E2=80=99d even hazard to say this is a solved issue for those that go aga=
inst
normalization of a relational model.

David J.

--0000000000000a8b140620ac947f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tuesday, August 27, 2024, Jan Bernitt &lt;<a href=3D"mailto:jaanbernitt@=
gmail.com" target=3D"_blank">jaanbernitt@gmail.com</a>&gt; wrote:<br><block=
quote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc=
 solid;padding-left:1ex"><div dir=3D"ltr"><br><div>So if nothing like this =
exists in postgreSQL I highly suggest starting to design JSON(B) functions =
that offer this flexibility :)</div></div></blockquote><div><br></div><div>=
PostgreSQL is both extensible and open source.=C2=A0 I highly suggest this =
seems like a perfect place for some enterprising people to leverage those a=
spects to improve things instead of burdening the core developers with more=
 work.=C2=A0 Given that pluggable procedural languages already have this ki=
nd of tooling I=E2=80=99d even hazard to say this is a solved issue for tho=
se that go against normalization of a relational model.</div><div><br></div=
><div>David J.</div><div><br></div>

--0000000000000a8b140620ac947f--