Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:100043
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 74.125.82.46 as permitted sender)
Date: Wed, 26 Jul 2017 13:42:05 +0100
User-Agent: K-9 Mail for Android
In-Reply-To: <6B.63.49004.FFD68795@pb1.pair.com>
References: <6B.63.49004.FFD68795@pb1.pair.com>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
To: internals@lists.php.net,=?UTF-8?Q?Micha=C5=82?= <aaatoja@o2.pl>
Message-ID: <F7215A26-7D22-42E7-8ED8-F94939182B49@gmail.com>
Subject: Re: [PHP-DEV] PDO native JSON / array support
From: rowan.collins@gmail.com (Rowan Collins)

On 26 July 2017 11:25:00 BST, "Micha=C5=82" <aaatoja@o2=2Epl> wrote:
>Most database systems have now native support for JSON format=2E Some of=
=20
>them, like PostgreSQL, also accepts arrays=2E I rememeber there was some=
=20
>fork of pgsql extension with native array support=2E
>
>Maybe it is time to extend PDO so it can accept at least one of these=20
>formats? What do You think?

Hi,

What would "support" exactly mean for a JSON type? Since JSON is a way of =
serialising data into a string, wouldn't all JSON values going into and out=
 of the database just look like strings to the driver?

For Postgres's array types, some support for serialising and unserialising=
 would definitely be useful, though, because the format is rather complex, =
particularly if you have multidimensional and sparse arrays=2E Obviously, u=
sers now have the workaround of transferring as JSON, but I know my last co=
mpany had a pair of utility functions to attempt this in userland, which we=
re known to be buggy in certain edge cases=2E

Regards,

--=20
Rowan Collins
[IMSoP]