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