Lorenzo Alberton

At a glance

A new beta release of MDB2 is out. Enjoy!

Print     Permalink

Latest articles

• PHP UK 2010: RDBMS in the social networks age
• Profiling PHP applications with XHProf: the path to scalability
• Speaking at the PHP Barcelona conference 2009
• New article: Graphs in the database, SQL meets social networks
• Create a video preview as animated GIF with FFmpeg and PHP SPL

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:

• MDB2 2.5.0b1
• MDB2_Driver_ibase 1.5.0b1
• MDB2_Driver_mssql 1.3.0b1
• MDB2_Driver_mysql 1.5.0b1
• MDB2_Driver_mysqli 1.5.0b1
• MDB2_Driver_oci8 1.5.0b1
• MDB2_Driver_pgsql 1.5.0b1
• MDB2_Driver_sqlite 1.5.0b1

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!

Lorenzo Alberton

Lorenzo works as a Consultant / Software Engineer at Ibuildings, always busy with many cool clients. He's a long-time contributor to many open source projects.

Tags

AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Imagick, INFORMATION_SCHEMA, JavaScript, Linux, mod_rewrite, MySQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework