Lorenzo Alberton

At a glance

A new stable 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.4.0 released

After four months of active developement since the last release, I'm proud to announce the new PEAR::MDB2 v.2.4.0. The list of updates is huge, especially in the drivers. Here's the changelog of each one:

• MDB2 2.4.0
• MDB2_Driver_ibase 1.4.0
• MDB2_Driver_mysql 1.4.0
• MDB2_Driver_mysqli 1.4.0
• MDB2_Driver_mssql 1.2.0
• MDB2_Driver_oci8 1.4.0
• MDB2_Driver_pgsql 1.4.0
• MDB2_Driver_sqlite 1.4.0

I've personally tested most drivers (Firebird SQL, MySQL, MySQLi, MS SQL Server, Oracle, PostgreSQL, SQLite) and made sure that everyone of them is in good shape. The MDB2 test suite was extended to cover (almost) all the public and private methods, also the ones in the Manager and Reverse modules that aren't "standard features" across all the DBMS, like TRIGGERs, VIEWs and FUNCTIONs.

The Manager and Reverse modules of all the drivers sport a load of new features, just browse the API docs and the official documentation (yes, it was improved/extended as well) for the details. I put a lot of effort in these modules, I hope they're useful. I would like to gather some comments about the new methods to retrieve the TRIGGER and FUNCTION definitions, please let me know if you like them and/or what you would change.

A special "thank you" goes to Andrew Hill and Monique Szpak for contributing some ideas/patches and a lot of new test cases, to Lukas for his advices and to all the other developers and contributors.

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