PEAR MDB2 is a merge of the PEAR DB and Metabase php database abstraction layers.

It provides a common API for all supported RDBMS. The main difference to most

other DB abstraction packages is that MDB2 goes much further to ensure

portability. MDB2 provides most of its many features optionally that

can be used to construct portable SQL statements:

* Object-Oriented API

* A DSN (data source name) or array format for specifying database servers

* Datatype abstraction and on demand datatype conversion

* Various optional fetch modes to fix portability issues

* 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) named and unnamed placeholder emulation

* Sequence/autoincrement emulation

* Replace emulation

* Limited sub select emulation

* Row limit emulation

* Transactions/savepoint support

* Large Object support

* Index/Unique Key/Primary Key support

* Pattern matching abstraction

* Module framework to load advanced functionality on demand

* Ability to read the information schema

* RDBMS management methods (creating, dropping, altering)

* Reverse engineering schemas from an existing database

* SQL function call abstraction

* Full integration into the PEAR Framework

* PHPDoc API documentation

via MDB2.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s