PEAR is discontinued

This is a static archive preserving historical releases and metadata. No new packages or updates will be published. For updates to existing packages, or to publish new packages, please use Composer and Packagist.

Home » Database » MDB

database abstraction layer

This package is unmaintained.

Download latest release 1.3.0 (archived versions might be outdated)

License: BSD style

Description

PEAR MDB 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 MDB goes much further to ensure
portability. Among other things MDB 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
* 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
* Wrappers for the PEAR DB and Metabase APIs
* PHPDoc API documentation
Currently supported RDBMS:
MySQL
PostGreSQL
Oracle
Frontbase
Querysim
Interbase/Firebird
MSSQL

Documentation

Manual

Maintainers

No maintainers.

Dependencies

No dependencies.

Releases

Bugs

IDStatusTypeVersionDateSummary
#108ClosedBug2003-10-15MDB 1.x getValue run in "Document contains no Data"
#148ClosedBug2003-10-23Database tables not created
#258ClosedBug2003-11-16Notice in 1.1.4RC4
#523ClosedBug2004-01-05Notice in 1.1.4 and earlier RC's
#590ClosedBug2004-01-16Oracle-specific error message text is not available in MDB
#625ClosedBug2004-01-26popexpecterror error with Oracle
#633ClosedBug2004-01-27"ORA-01002 Fetch Out Of Sequence" error
#670ClosedBug2004-02-02fetchCol error on empty result
#681ClosedBug2004-02-04Oracle numRows() now returns -1 if no row
#718ClosedBug2004-02-09oci8 fetchInto ->causing some values are overwritten
#740ClosedBug2004-02-12before 4.3.0 release, pg_fetch_assoc isn't work
#763ClosedBug2004-02-15common.php v1.114.4.15 introduced MDB2 constants
#764ClosedBug2004-02-15Wrong test mysql.php v1.80.4.9
#801ClosedBug2004-02-19currId() for oci8 driver
#887BogusBug2004-02-26PEAR QA: improvement for get_class()-usage
#909ClosedBug2004-02-26PEAR QA: improvement for get_class()-usage
#946ClosedBug2004-03-04OCIFetchInto:ORA-01002:fetch out of sequence if numrows() called before
#963ClosedBug2004-03-07Notice: Undefined index: Key_name in /Modules/Manager/mysql.php on line 707
#965ClosedBug2004-03-07[MDB1] bug #946 fix -> fetchInto infinite loop if numRows() called before
#968ClosedBug2004-03-07[MDB1] Feature request: oci8 listTables()
#975ClosedBug2004-03-08[MDB1] oci8 feature request: listTableFields()
#984BogusBug2004-03-09Error with 'DECLARE select_cursor CURSOR'
#985ClosedBug2004-03-09[MDB1] mssql.php: missing ' ; '
#1003ClosedBug2004-03-12[MDB1] mssql feature request: listTableFields()
#1004ClosedBug2004-03-12[MDB1] mssql feature request: listTables()
#1087ClosedBug2004-03-28query limits in INSERT queries
#1146Wont fixBug2004-04-06Sequence name length problem
#1159ClosedBug2004-04-07[MDB1] mysql.php manager getTableFieldDefinition small bugs
#1167ClosedReq2004-04-09MDB1] mssql feature request: getTableFieldDefinition() for mssql
#1168ClosedBug2004-04-09mysql manager getTableFieldDefinition() and listTableFields() bug
#1292ClosedBug2004-04-26[MDB1] mssql feature request: listTableIndexes()
#1424ClosedBug2004-05-17bug in dumpDatabase / listTableIndexes
#1751ClosedBug2004-06-30use of undefined variable in MDB/Common.php:3654
#1914ClosedBug2004-07-19Mysql getTableFieldDefinition
#1915BogusBug2004-07-20Undefined Offset when doing fetchRow
#2434ClosedBug2004-10-01typo in source code
#2616ClosedReq2004-10-25Add quiteIdentifer() from MDB2 to MDB
#3113ClosedBug2005-01-05captureDebugOutput() is not working
#3144BogusReq2005-01-09Additional fetchmode for better oracle compatibility
#3146ClosedBug2005-01-10oci8->fetchInto with rownum does not remember fetched row count
#3219ClosedReq2005-01-17Column alias for Interbase
#3281BogusBug2005-01-24empty_clob/empty_blob handling does not work with oracle
#3337BogusReq2005-01-31execute overwrites setParam statements
#3371BogusBug2005-02-03no numRows with an oracle "select...for update" query
#3424ClosedBug2005-02-10Notice and wrong error check
#3495ClosedBug2005-02-16Fatal error using MDB to access interbase database
#3698Wont fixReq2005-03-04Tutorial documentation
#3770ClosedBug2005-03-10in ibase module when you call auto_commit(false) don't start transaction
#3771ClosedBug2005-03-10the function commit in ibase module don't work with transaction/auto_commit
#3774ClosedBug2005-03-11commit and rollback methd not update the property in_transaction in ibase
#3917Wont fixBug2005-03-22problems in setSelectedRowRange()
#3928ClosedBug2005-03-23ibase module dont support charset/buffers/dialect/role parameters
#4515ClosedBug2005-06-02rendering logic error