Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:100059 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 72370 invoked from network); 27 Jul 2017 12:03:05 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 27 Jul 2017 12:03:05 -0000 Authentication-Results: pb1.pair.com header.from=phofstetter@sensational.ch; sender-id=pass Authentication-Results: pb1.pair.com smtp.mail=phofstetter@sensational.ch; spf=pass; sender-id=pass Received-SPF: pass (pb1.pair.com: domain sensational.ch designates 195.226.6.199 as permitted sender) X-PHP-List-Original-Sender: phofstetter@sensational.ch X-Host-Fingerprint: 195.226.6.199 mail.sensational.ch Received: from [195.226.6.199] ([195.226.6.199:59039] helo=mail.sensational.ch) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id D5/E4-17354-376D9795 for ; Thu, 27 Jul 2017 08:03:00 -0400 X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-transfer-encoding; bh=EFU1f/DqANyvwCvZfwK0wajvTBjl+qPRR23KLk6qm+U=; b=EarEn6ssK3DvXBoEIpND7M33+F6xwBV9IP3bOx4+5WaxqUT9UwLzmqEYsYhjOa+Y4G aLmjC4guuc5vBMIgGTkpRRRJTJXZ8O0oH0MU91AEfTvQDahVHdnZ7rZB/JwjP64o+gK+ kvohMCUCV5eQJ6I4MO9ydDKSw3NQtjLtN++kixcbAn/HOBuRs2ze/JKmZRr60B4Hn0/7 TrLVLhiXwNUK0E+sXWg4VeLLLaPJHzkLrtvNom0wMW7WZt3AmQE8fER1p6+oQt+uSfh/ +W9GGADpM+SEMrs1neI4e34dcR5Nk4KDjwnlq3Y0njLz0yLypCumLie+dSsDRPs7cMlG GcUg== X-Gm-Message-State: AIVw112hKZGI7vnOSTpufnurXIu9s//yxVIR1rROzzMr85NDu4iiHzqL 39HksQm2Ij8eGiNwQJE1Gp36zZwNgAfjv8jPHuSpBsYQRvhhi49W9tEDEF2eaG/B23xwvEz5l4F b4KAbE4b3tCth/aHiL697EwXN/6YLtWtMfIw= X-Received: by 10.200.56.54 with SMTP id q51mr5453602qtb.338.1501156975308; Thu, 27 Jul 2017 05:02:55 -0700 (PDT) X-Received: by 10.200.56.54 with SMTP id q51mr5453570qtb.338.1501156974893; Thu, 27 Jul 2017 05:02:54 -0700 (PDT) MIME-Version: 1.0 In-Reply-To: <6B.63.49004.FFD68795@pb1.pair.com> References: <6B.63.49004.FFD68795@pb1.pair.com> Date: Thu, 27 Jul 2017 14:02:34 +0200 Message-ID: To: =?UTF-8?Q?Micha=C5=82?= Cc: PHP internals Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-SA-Do-Not-Run: Yes X-SA-Exim-Connect-IP: 209.85.216.197 X-SA-Exim-Mail-From: phofstetter@sensational.ch X-SA-Exim-Scanned: No (on mail.sensational.ch); SAEximRunCond expanded to false Subject: Re: [PHP-DEV] PDO native JSON / array support From: phofstetter@sensational.ch (Philip Hofstetter) 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 in such a feature was low, so I never completed work on this, but maybe it's something you might want to play with. Some more info here: https://blog.pilif.me/2014/03/28/pdo_pgsql-improvement= s/ Philip On Wed, Jul 26, 2017 at 12:25 PM, Micha=C5=82 wrote: > Most database systems have now native support for JSON format. Some of th= em, > 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? > > -- > PHP Internals - PHP Runtime Development Mailing List > To unsubscribe, visit: http://www.php.net/unsub.php > --=20 Sensational AG Giessh=C3=BCbelstrasse 62c, Postfach 1966, 8021 Z=C3=BCrich Tel. +41 43 544 09 60, Mobile +41 79 341 01 99 info@sensational.ch, http://www.sensational.ch