Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:88069
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain schlueters.de from 217.114.215.10 cause and error)
Message-ID: <1441581781.24572.8.camel@kuechenschabe>
To: Andrea Faulds <ajf@ajf.me>
Cc: internals@lists.php.net
Date: Mon, 07 Sep 2015 01:23:01 +0200
In-Reply-To: <7A.E4.59944.DF67CE55@pb1.pair.com>
References: 
	<CAKws9z0N7d9oxOegJpdOkRDmmPPimd0YLcgY-_H1HcLMYYcxeA@mail.gmail.com>
	 <7A.E4.59944.DF67CE55@pb1.pair.com>
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] Re: PDO: Disable emulated prepares by default?
From: johannes@schlueters.de (Johannes =?ISO-8859-1?Q?Schl=FCter?=)

On Sun, 2015-09-06 at 18:25 +0100, Andrea Faulds wrote:
> Hi Scott,
> 
> Scott Arciszewski wrote:
> > Inspired by http://stackoverflow.com/a/12202218/2224584
> >
> > Can we (in either PHP 7.0 or in PHP 7.1) turn emulated prepared
> > statements off by default, and still allow developers to turn it on if
> > they really want them?
> >
> > For now my code works around this design decision, but not everybody
> > is cognizant of this behavior.
> 
> I don't know if there's really still time to add this in PHP 7.0, but I 
> think emulated prepares being switched off would be a good idea. One 

Good enough to take the performance hit by the extra roundtrip?

> reason in particular is that this means we'd get properly typed results, 
> rather than just strings, which would work better with PHP 7's new 
> scalar type hints. PDO returning strings everywhere when using emulation 
> was one thing I was completely unaware of until I turned on strict typing.

For some definition of "properly". Large integers might still become
strings, same for decimals etc. Also if you might use other databases
than MySQL still anything might happen.

Also mind that there are subtle differences on what can be done. A bit
constructed example but in MySQL you can't prepare
   CREATE TABLE foo (id INT DEFAULT ?)
while PDO would let you do this.

johannes