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.1 released

I just released a new minor version of PEAR::MDB2. Now DECIMAL and NUMERIC data types are first-class citizens just like the others: you can specify (and retrieve) both the precision and the scale values on a per-field basis, so you don't have to resort to the 'decimal_places' option which is global to all the fields. A similar fix is included in MDB2_Schema already, so you can use something like this in your XML schema definition:

<field>
   <name>revenue</name>
   <type>decimal</type>
   <length>10,4</length>
   <notnull>false</notnull>
</field>

The MDB2 v.2.4.1 release also features a number of important fixes (including a patch for a regression bug in MySQL and MySQLi transaction support, and a patch for a memory leak in the prepare/execute statements), so I warmly recommend you to upgrade.

Changelog

• 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

Subpackages

Thanks to a nice feature of the PEAR installer, since MDB2 v.2.4.0 you can install/upgrade the drivers in this simple way:

$ pear install MDB2#mysql
$ pear upgrade MDB2#pgsql

How nice is that?

As usual, many thanks to all the contributors and bug reporters.

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