Hi folks. I have a question about database abstraction. If this is not the place to ask, please redirect me.
There are millions of PHP-scripts using MySQL. Most of them probably doesn't use an Database Abstraction Layer (DBAL) in order to support other databases. When the requirement is made some day that a script should support another DB than MySQL programmers are facing the challenge of literally rewrite most of their code to fit some DBAL, like ADOdb or whatever. So my idea was to make a DBAL which basically offers a parallel set of functions to the current MySQL-functions (search/replace) but internally parses the queries and re-makes the query into something Oracle or MSSql or some third DB would understand. This would be totally transparent and give instant DBA to millions of PHP-scripts. A "MySQL emulator". For MySQL it wouldn't affect performance. For other DBs I would require a little parsing time of the query. I know this is not as simple as it sounds, but is it *totally impossible* since noone made it yet and if some of you think it is, please let me know why. I think the idea is obvious. - kasper --------------------- Q: So who is going to drive TYPO3 ahead? A: The man in the mirror! -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, visit: http://www.php.net/unsub.php
