Re: [PDO] PDO version 1 improvements

On 06.05.2008, at 21:17, Ulf Wendel wrote:

> - introduce FLOAT type in PDO

was already on there along with date/timestamp support

> - don't enforce usage of Prepared Statements, allow simple statements
>  prepare() can be an overhead its not always faster

has been added to the rfc

> - don't emulate named parameters if the driver does not support it
>  I wonder if named parameters are part of any SQL standard and why  
> PDO once again ignores the world outside and tries to emulate stuff  
> not all databases support to end up in a poor emulation.

I am not sure that prepared statements are part of the standard at  
all. most rdbms simply followed odbc. postgresql and oracle both have  
their own syntax. in order to make it possible to write portable code,  
at the very least parsing and rewriting to these two rdbms must be  
supported. that being said, i think the postgresql and oracle syntax  
is the most flexible (allows reusing the same parameter multiple  
times) and also the more readable (since placeholders may be named).  
So I do not agree that this is a bad feature. I do agree that the  
parser is way too simplistic and this is already noted in the rfc. The  
parser in MDB2 works quite reliably (I do not remember having much of  
any tickets), though I am not a parser expert, so it could probably be  
implemented more efficiently.

regards,
Lukas