Re: New PDO-based DBAL/ORM for PEAR2

Im sorry i cannot agre on this. Diferent RDBMS different indexes diffeent behvior. The dbal help you connect and do a certain amount of things but in orderto be perormant you need to ptimize the relevant queries according to your needs. Somequeries will essentially e the same ut not all of them. On 11/20/07, Bertrand Mansion <golgote@mamasam.com> wrote: > > 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 > > -- > PEAR Development Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- David Coallier, Founder & Software Architect, Agora Production (http://agoraproduction.com) 51.42.06.70.18