[ANNOUNCEMENT] MDB2-2.0.0beta1 (alpha) Released.

The new PEAR package MDB2-2.0.0beta1 (alpha) has been released at http://pear.php.net/. Release notes ------------- - fixed bug in MDB2::singleton - fixed minor bugs in prepare/execute - added PEAR::DB wrapper (not working yet) - fixed several bugs in the ibase driver - fixed several PHP5 related issues - fixed bug in sequence creation on MySQL - fixed issues with nextid() ondemand handling in conjunction with currId() - added native currId() implementation for the Oracle driver - fixed sqlite driver (passes all but the REPLACE test due to a conformance issue in sqlite itself) - removed decimal_factor property to allow changing of decimal_places option - using native escape string methods in sqlite and mysql driver - fixed minor conformance issues in tableInfo() in the oci8 and mysql driver - removed optimize option and added portability option instead (ported from DB) - added quoteIdentifier() method (ported from DB) - added STATUS document to make the status of the drivers more transparent - fixed a few bugs in querysim driver - fixed issue in mysql reverse engineering: ensuring the correct case is used when doing assoc fetches based on portability flag setting - updated reverse engineering script to the new MDB2 API - removed broken implementations of currId() in the mssql and fbsql driver - fixed a few instances of MDB_Common to the new class name of MDB_Driver_Common Package Info ------------- PEAR MDB2 is a merge of the PEAR DB and Metabase php database abstraction layers. It provides a common API for all support RDBMS. The main difference to most other DB abstraction packages is that MDB2 goes much further to ensure portability. Among other things MDB2 features: * An OO-style query API * A DSN (data source name) or array format for specifying database servers * Datatype abstraction and on demand datatype conversion * Portable error codes * Sequential and non sequential row fetching as well as bulk fetching * Ability to make buffered and unbuffered queries * Ordered array and associative array for the fetched rows * Prepare/execute (bind) emulation * Sequence emulation * Replace emulation * Limited Subselect emulation * Row limit support * Transactions support * Large Object support * Index/Unique support * Module Framework to load advanced functionality on demand * Table information interface * RDBMS management methods (creating, dropping, altering) * RDBMS independent xml based schema definition management * Altering of a DB from a changed xml schema * Reverse engineering of xml schemas from an existing DB (currently only MySQL) * Full integration into the PEAR Framework * PHPDoc API documentation Currently supported RDBMS: MySQL PostGreSQL Oracle Frontbase Querysim Interbase/Firebird MSSQL SQLite Other soon to follow. Related Links ------------- Package home: http://pear.php.net/package/MDB2 Changelog: http://pear.php.net/package-changelog.php?package=MDB2 Download: http://pear.php.net/get/MDB2-2.0.0beta1.tgz Authors ------------- Lukas Smith <smith@backendmedia.com> (lead) Paul Cooper <pgc@openadvantage.org> (contributor) Frank M. Kromann <frank@kromann.info> (contributor) Lorenzo Alberton <l.alberton@quipo.it> (contributor)