Database Abstraction
| From: | Kasper Skårhøj | Date: | Wed, 05 Feb 2003 16:57:41 +0000 |
| Subject: | Database Abstraction | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-94034@lists.php.net to get a copy of this message | ||
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!