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