Dibi

dibi is a small and fast database abstraction library for PHP. It allows developers to write applications in a fairly consistent way regardless of the underlying database storing the information. The advantage is that the database can be changed without re-writing every call to it in the application.
It supports the following databases:
*Access (via ODBC)
*Microsoft SQL Server
*MySQL
*Oracle
*PDO
*PostgreSQL
*SQLite
Each database implements SQL slightly differently, the developer will need to be aware of the database-specific features and syntax to avoid if they want to maintain portability. Dibi provides format and literals conversion functions so that you can create values in any format and insert them into your SQL in the correct format for your database.
Some databases support the LIMIT and OFFSET statements. Dibi translates limit and offset to different mechanisms for each database and can emulate limit for databases with no native limit equivalent.
Dibi supports transactions, has SQL logger and profiler, uses PHP 5 language features.
 
< Prev   Next >