LWN.net Logo

Still no "standard" DBI equivalent?

Still no "standard" DBI equivalent?

Posted Jul 24, 2004 13:41 UTC (Sat) by topher (guest, #2223)
Parent article: What's new in PHP 5?

What I don't understand is why there seems to still be no "standard" equivalent to Perl's DBI. Why do we have to use completely different interfaces for every database we want to talk to?

Heck, here PHP5 is, touting the new MySQL support library, and also a new SQLite support library. . . and I'm left wondering why it is that they're not extolling the virtue of a standardized SQL access library, that can be used nearly transparently with SQLite, MySQL, PostgreSQL, Oracle, etc.

Having to write different PHP code to support different databases, or being forced to find your own database independant interface is just silly.

It's funny, most Perl applications that support a database can, with minimal work, support any database you want to use.

PHP, on the other hand, is usually MySQL, or nothing.

Here's a wake-up call, guys. A large number of people out there don't use MySQL, and don't plan to use it. Some of us actually *need* things that a true ACID compliant RDBMS offers, that MySQL doesn't. MySQL might work 5 years from now, but it doesn't do what I need now.

Oh, well. Nice to see PHP is still being developed. . . I'm going back to Perl, now.


(Log in to post comments)

Still no "standard" DBI equivalent?

Posted Jul 24, 2004 23:53 UTC (Sat) by tarvin (subscriber, #4412) [Link]

See PEAR DB for the "standard" database abstraction layer for PHP. There are others, perhaps most notably ADOdb.

By the way: Currently, there seems to be much discussion about database abstraction layers in general. See Lambda the Ultimate's discussions for just some of the opinions.

Copyright © 2008, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds