Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:68039
Return-Path: <yohgaki@gmail.com>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 91061 invoked from network); 2 Jul 2013 18:18:16 -0000
Received: from unknown (HELO lists.php.net) (127.0.0.1)
  by localhost with SMTP; 2 Jul 2013 18:18:16 -0000
Authentication-Results: pb1.pair.com smtp.mail=yohgaki@gmail.com; spf=pass; sender-id=pass
Authentication-Results: pb1.pair.com header.from=yohgaki@gmail.com; sender-id=pass
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.215.48 as permitted sender)
X-PHP-List-Original-Sender: yohgaki@gmail.com
X-Host-Fingerprint: 209.85.215.48 mail-la0-f48.google.com  
Received: from [209.85.215.48] ([209.85.215.48:58782] helo=mail-la0-f48.google.com)
	by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP
	id B2/50-23285-66913D15 for <internals@lists.php.net>; Tue, 02 Jul 2013 14:18:15 -0400
Received: by mail-la0-f48.google.com with SMTP id lx15so5801210lab.21
        for <internals@lists.php.net>; Tue, 02 Jul 2013 11:18:12 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:sender:in-reply-to:references:from:date
         :x-google-sender-auth:message-id:subject:to:cc:content-type;
        bh=bJrYJ8z8HbG0eTUjyhkAjjADMi5YTpuiEWxkb8YcM6M=;
        b=eXKGse5q82SlfxoQzFsdmWmReoEp4R+FKYumbsnjO73UC9fN3l08w+52BF1N2C7zum
         1Tuzsh+Jll/QI57cf2/dkPXqKWD8LpXTKb90mA3ITiwX/snO4G7OkltO9NTCK0jk/Lip
         O3tyjh7Ghnbp177W2VajQvMr/uUG0+Clik0Ns5ON6+8onVriCAuhwIos9EIHniwYuO7e
         TwMK8nMURFDKzzl9QJDYrN12L+/e/BCYBVA5nhjhvZk5Sfv7wS0RHjI7SbV99x7KF2aG
         1UrrKP6lcncOfmTvKinZIMrb+K6FJ0zuc69feW5EFQ8gbr3Y6G9nkgo28w9qPc6Pb7e/
         Yv8w==
X-Received: by 10.152.28.199 with SMTP id d7mr14950675lah.67.1372789092030;
 Tue, 02 Jul 2013 11:18:12 -0700 (PDT)
MIME-Version: 1.0
Sender: yohgaki@gmail.com
Received: by 10.112.4.233 with HTTP; Tue, 2 Jul 2013 11:17:30 -0700 (PDT)
In-Reply-To: <51D2B381.2080602@beccati.com>
References: <CAGa2bXYbo++wkYynN+SZ0bDZQjrvu+Q-CeEDh+9nWCfyt4K5jg@mail.gmail.com>
 <51CAB115.60602@beccati.com> <CAGa2bXYJT+nZFjWht_MpYRitgJ9-N=yVzsJoqax_FVc3pmqqdg@mail.gmail.com>
 <51D29355.9040807@beccati.com> <CAGa2bXZ4Hsj0G9Wvp9T5m0KWfJ2P3u42vBcEC5EmuRCHKvyMdg@mail.gmail.com>
 <51D2AC78.3040206@beccati.com> <CAGa2bXZv5DqyVmzqPyVBt3wZ9cKRLbrX1eAgsZnzRkh-71kRUQ@mail.gmail.com>
 <51D2B381.2080602@beccati.com>
Date: Wed, 3 Jul 2013 03:17:30 +0900
X-Google-Sender-Auth: -Ig3fEV3sz3HUdDMl463v7zCi3k
Message-ID: <CAGa2bXZvk2_bkE9643zcWEwfafzmf=C2nhSvcBEFO+NsPj4AeA@mail.gmail.com>
To: Matteo Beccati <php@beccati.com>
Cc: "internals@lists.php.net" <internals@lists.php.net>
Content-Type: multipart/alternative; boundary=089e0160b4322ea03104e08b5ecb
Subject: Re: [PHP-DEV] pgsql: Binary data support improvement
From: yohgaki@ohgaki.net (Yasuo Ohgaki)

--089e0160b4322ea03104e08b5ecb
Content-Type: text/plain; charset=ISO-8859-1

Hi Matteo,

2013/7/2 Matteo Beccati <php@beccati.com>

> I'm talking about parameters, not results. The speedup would be only for
> inserts, not selects (which would require something that's not available
> in libpq).
>

For insert or update, binary can be inserted/updated directly.
If we do this transparently to users, we need additional select query to
system catalog to find field type.

Since pgsql is not a db access abstraction layer, adding a array parameter
that indicates which field is binary or text may be the way to go. Lack of
reverse operation would be problematic, though.

We may wait until PostgreSQL implements appropriate API.

Regards,

--
Yasuo Ohgaki
yohgaki@ohgaki.net

--089e0160b4322ea03104e08b5ecb--