[TYPO3-dev] TYPO3 and MySQL Strict Mode

[Ries van Twisk]

On Jul 12, 2009, at 7:09 AM, Dmitry Dulepov wrote:

> Hi!
>
> Jigal van Hemert wrote:
>> Yet another issue that could be solved by using something like PDO  
>> (PHP
>> Data Objects), which is also supported by AdoDB. Parameter binding in
>> prepared statements in PDO solves the entire escaping and quoting  
>> issue.
>
> PDO is unacceptably slow. No go for TYPO3, sorry.
>



For people that uses multiple databases it would be a hell lot easer if
TYPO3 would have used or changed to PDO or a AdoDB object by nature.
This could also saved us from some SQL injection issues...

Although PDO/AdoDB is slower then direct DB functions,
TYPO3 in general spend a lot more then juggling arrays and
executing code in PHP rather then communicating with the DB.
 From an enterprise point of view it's strange that TYPO3 doesn't
support out-of-the-box any other DB well.

DBAL is IMHO not a enterprise solution because it's not a 100% solution
and more like a hack then anything else. Patches from Xavier are still  
pending.......



			regards, Ries van Twisk


-------------------------------------------------------------------------------------------------
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?