Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:101044
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain beccati.com designates 176.9.123.236 as permitted sender)
To: Scott Arciszewski <scott@paragonie.com>,
 PHP Internals <internals@lists.php.net>
References: <CAKws9z1CeGHDmJ7hvX=mTXabMY+2fWgCjJw1N03bLZ=6PAsVng@mail.gmail.com>
Message-ID: <7e7d69c9-8383-9cd0-9a54-0e7e4bb80775@beccati.com>
Date: Fri, 3 Nov 2017 20:49:20 +0100
MIME-Version: 1.0
In-Reply-To: <CAKws9z1CeGHDmJ7hvX=mTXabMY+2fWgCjJw1N03bLZ=6PAsVng@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: en-GB
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] Idea: PDO - Single-round-trip prepared statements
From: php@beccati.com (Matteo Beccati)

Hi Scott,

On 03/11/2017 16:33, Scott Arciszewski wrote:
> 1. Which DB drivers (and which versions) support 1RT prepared statements in
> addition to 2RT prepared statements?
> 2. Is there a better name for this usage than safeQuery()?
> 
> If this turns out to be a good idea, I'll write up an RFC targeting PHP 7.3.

I've added a similar feature to pdo_pgsql a while ago
(PDO::PGSQL_ATTR_DISABLE_PREPARES), which is not enabled by default.

It is basically somwthing in between real prepared statements (which is
the default on pdo_pgsql) and emulated prepares, and it uses libpq's own
PQexecParams function.

At that time I had checked if libmysqlclient offered a similar function,
but it didn't seem like it, so I went for the pgsql-only constant.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/