PEAR MDB2 2.5.0b1 released

Finally, the new PEAR::MDB2 1.5.0beta1 is out!
The number of fixed bugs and new features since the last stable release is impressive. The bravest of you that already installed the alpha version may have tried some of these already, anyway here's a preview of what's new:

  • added alterDatabase(), truncateTable() and vacuum() abstraction in the Manager module
  • added length() and unixtimestamp() functions abstraction in the Function module
  • added partial support for CHECK constraints
  • added full support for FOREIGN KEY constraints, both in the Reverse and in the Manager module. For the DBMS that do not enforce the FK constraints or their ON UPDATE / ON DELETE actions, there's now a nice emulation of these features thanks to some TRIGGERs that are automatically created for you.
  • better overall charset/collation support

A huge number of little fixes and a careful QA process make this package stabler than ever. This is also possible thanks to you, the users, and the bug reporters. A special "thank you" to Ali Fazelzadeh for joining the team, welcome on board!

Here's the detailed changelog for the various drivers:

And now, go an try the new release yourself. To install / upgrade:

$ pear config-set preferred_state beta
// install the base DBAL:
$ pear install MDB2
// install one or more drivers:
$ pear install MDB2#ibase
$ pear install MDB2#mssql
$ pear install MDB2#mysql
$ pear install MDB2#mysqli
$ pear install MDB2#oci8
$ pear install MDB2#pgsql
$ pear install MDB2#sqlite
// to upgrade, replace "pear install" with "pear upgrade"

Have fun!

2 responses to "PEAR MDB2 2.5.0b1 released"

I\'ve been using MDB2 for a while, and it\'s central to a number of projects, but doesn\'t appear to like 2.5.3 very much, and hasn\'t been updated for ages. Should I be looking for a new abstraction library, or do you intend to return to it?

Hi Nicholas,
please check out a copy of MDB2 from SVN, it\'s fully PHP5.3 compatible, with many performance improvements. I\'m currently waiting for some fixes to the new SQL Server driver (Microsoft is working on it this very week), then I\'ll push a new stable release.

Lorenzo Alberton

Lorenzo Alberton Lorenzo has been working with large enterprise UK companies for the past 10+ years and is currently CTO at DataSift. He's an international conference speaker and a long-time contributor to many open source projects. Lorenzo Alberton's profile on GitHub Lorenzo Alberton's profile on LinkedIN View Lorenzo Alberton's profile on PHP PEAR
View Lorenzo Alberton's Twitter stream Lorenzo Alberton - Sun Certified MySQL 5 Developer PHP5 ZCE - Zend Certified Engineer


AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Hadoop, Imagick, INFORMATION_SCHEMA, JavaScript, Kafka, Linux, Message Queues, mod_rewrite, Monitoring, MySQL, NoSQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework
Buy me a book - The Best Software Writing 1