[Solar-talk] Oh and 'Database Support'

[stefan bogdan]

hi Paul, 
every rdbms have more or less follow the ansi standard.
i guess that is not possible to write 100% compatible database driver, as  someone said: if you want to write portable application
it will perform badly on one database and it will be worst with the rest. 
but with all that , i think that Solar should support Oracle . 
Oracle is probably not yet used extensivly in php enviroment, but is a very competitive rdbms.
We should see the every rdbms have some brake in sql implementation : http://troels.arvin.dk/db/rdbms/ and http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html.
Even Mysql, that is the favorite in the web applications, have some serios limitions until 4 and 5 versions.
MSSQL, DB2 and Oracle should not be let outside Solar database support.
Also supporting php's database native drivers, can be an option. As i've seen PDO drivers have some 'bugs' and seems
to stay there forever. To me (in my tests) native drier was faster than PDO equivalent (with oracle). This will probably
take Solar database implementation a little bit heavier, but IMO more complete.
As you may remember i've made a proposal regarding oracle pdo driver http://solarphp.org/wiki/proposals/OracleDriver.
Not sure that it works anymore :-(.


 regards,
bogdan




       
____________________________________________________________________________________
Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman-mail3.webfaction.com/pipermail/solar-talk/attachments/20070720/29cca6f2/attachment.html