Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:68035
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.128.42 as permitted sender)
MIME-Version: 1.0
Sender: yohgaki@gmail.com
In-Reply-To: <51D2AC78.3040206@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>
Date: Tue, 2 Jul 2013 19:52:02 +0900
Message-ID: <CAGa2bXZv5DqyVmzqPyVBt3wZ9cKRLbrX1eAgsZnzRkh-71kRUQ@mail.gmail.com>
To: Matteo Beccati <php@beccati.com>
Cc: "internals@lists.php.net" <internals@lists.php.net>
Content-Type: multipart/alternative; boundary=089e0149ce04ffabeb04e08524c5
Subject: Re: [PHP-DEV] pgsql: Binary data support improvement
From: yohgaki@ohgaki.net (Yasuo Ohgaki)

--089e0149ce04ffabeb04e08524c5
Content-Type: text/plain; charset=ISO-8859-1

Hi Matteo,

2013/7/2 Matteo Beccati <php@beccati.com>
>
> > The API is not for ease of use, but for better performance as it
eliminate
> > needless hex conversions on both server and client side.
>
> What I meant is that we might have that speed improvements for free in
> PDO when bytea is used as a parameter (i.e. most likely insert/updates).
> With no visible change for the user and full backwards compatibility.


libpq's query API only has flag that returns all result as binary or text.

http://www.postgresql.org/docs/9.2/static/libpq-exec.html

PGresult *PQexecParams(PGconn *conn,
                       const char *command,
                       int nParams,
                       const Oid *paramTypes,
                       const char * const *paramValues,
                       const int *paramLengths,
                       const int *paramFormats,
                       int resultFormat);

resultFormat is the flag for returned values, binary or text.

resultFormat
  Specify zero to obtain results in text format, or one to obtain results
in
  binary format. (There is not currently a provision to obtain different
  result columns in different formats, although that is possible in the
  underlying protocol.)

How it could be done while there isn't API in libpq?
Does PDO pgsql driver use low level (protocol level) tweak?
I'll check code later, but I don't have time for now.

Regards,

--
Yasuo Ohgaki
yohgaki@ohgaki.net

--089e0149ce04ffabeb04e08524c5--