Hi,
I few years ago, I did a throwaway implementation for this for reading:
https://github.com/pilif/php-src/tree/pdo_pgsql-improvements
This supports columns of type jsonb, json and text[] and I was
considering also adding support for the various timestamps, date and
so on.
Generally, interest
On Do, 2017-07-27 at 08:14 +0200, Michał wrote:
> Encoding data to insert query is simple. But selecting data requires
> additional magic and processing.
The magic while reading is quite limited - at least for MySQL the
protocol contains a flag in the meta data telling whether a field is a
"arbit
Encoding data to insert query is simple. But selecting data requires
additional magic and processing.
--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php
On 26 July 2017 14:02:03 BST, "Michał" wrote:
>JSON should be automatically converted to proper type(s).
>
>$data = ['name' => 'John'];
>$sth = $dbh->prepare('INSERT INTO table (json_column) values (:data)');
>$sth->bindParam(':data', $data, PDO::PARAM_JSON); // new parameter
>
>
>SELECT json_colu
On Mi, 2017-07-26 at 15:02 +0200, Michał wrote:
>
> JSON should be automatically converted to proper type(s).
>
> $data = ['name' => 'John'];
> $sth = $dbh->prepare('INSERT INTO table (json_column) values
> (:data)');
> $sth->bindParam(':data', $data, PDO::PARAM_JSON); // new parameter
>
>
> SE
>
> 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
On 26 July 2017 11:25:00 BST, "Michał" wrote:
>Most database systems have now native support for JSON format. Some of
>them, like PostgreSQL, also accepts arrays. I rememeber there was some
>fork of pgsql extension with native array support.
>
>Maybe it is time to extend PDO so it can accept at
Most database systems have now native support for JSON format. Some of
them, like PostgreSQL, also accepts arrays. I rememeber there was some
fork of pgsql extension with native array support.
Maybe it is time to extend PDO so it can accept at least one of these
formats? What do You think?
-
