MDB2

PEAR::MDB2 database abstraction layer

AdvancedSearch | AreaMap ]

Search:

  MDB2 Homepage   MDB2News   Documentation   ToDo   ChangeLog   MDB2Tools  
   

Username:

Password:


Areas In
This Wiki

BEPHPUG

Conferences

emPHPower

LiveUser

Main

MDB2

PDO

PEARThinkTank

PHPSVN

PHPTODO

RDBMS

WebBuilder2

MDB2 Homepage

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

Compatible with PHP 4.3.x upto 5.x

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. 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/Savepoint 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
  • Full integration into the PEAR Framework
  • PHPDoc API documentation

Currently supported RDBMS:
MySQL (ext/mysql and ext/mysqli)
PostGreSQL
Oracle oci8
Frontbase (unmaintained)
Querysim (unmaintained)
Interbase/Firebird 2
MSSQL
SQLite

Wiki syntax
If you are new to the wiki way have a look here.

Last changes
http://wiki.pooteeweet.org/changes.php?area=MDB2

MDB2:HomePage (lsmith)
Mon, 24 Sep 2007, 18:21
[ Links | Source | History | RSS ]

This site powered by YaWiki 0.22 beta.