Re: New PDO-based DBAL/ORM for PEAR2

Le 20 nov. 07 à 16:49, Lukas Kahwe Smith a écrit :

Funny that I managed to port my CMS from MySQL to PostgreSQL in 2 hours (mostly fixing reliance on non deterministic group by's) and to SQLite in 3 hours (1 hour was used to add a feature to handle the fact the SQLite by default qualifies joined columns with the table name unless aliased) as it was based on MDB2. I should also mention that the installation tools based on MDB2_Schema needed no alterations. I also did not feel like I was artificially limiting myself. For example one thing that did require custom code was the internal search, which was based on MySQL's FULLTEXT indexes. But that was a minimal amount of work and a tiny addition to the code. Just to set the record straight.

Actually, 2-3 hours sounds quite long to me given the fact that you know those databases well and that you wrote MDB2 :) Furthermore, I don't think you accounted MySQL Fulltext replacement in your 2-3 hours neither. A real abstraction would allow a database change in 5 minutes, just the time it takes to change the DSN. If you know beforehand that your application will have to work on different databases, you choose the SQL you use carefully, then the switch is even faster than 2-3 hours. There is no need to use a "slow as hell" layer to do this, especially when PDO does most of the ugly job. -- Bertrand Mansion Mamasam Work : http://www.mamasam.com Blog : http://golgote.freeflux.net