- ADOdb
Infobox Software
name = ADOdb
caption =
collapsible =
author =
developer =
released =
latest release version =
latest release date =
latest preview version =
latest preview date =
frequently updated =
programming language =PHP , Python
operating system =
platform =
size =
language =
status =
genre = Database abstraction library
license = BSD / LGPL
website = http://adodb.sourceforge.net/ADOdb is a database abstraction library for
PHP and Python based on the same concept as Microsoft'sActiveX Data Objects . 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.From the [http://adodb.sourceforge.net/ ADOdb website] and developer sites, it supports the following databases:
*ActiveX Data Objects *
*DB2
*Firebird
*Foxpro
*FrontBase
*Informix
*Interbase
*LDAP
*Microsoft Access
*Microsoft SQL Server
*MySQL
*Netezza
*Oracle
*PostgreSQL
*SAP DB
*SQLite
*Sybase
*Teradata
* Valentina
*generic ODBC andODBTP ADOdb uses
SQL . Since each database implements SQL slightly differently, the developer will need to be aware of the database-specific features and functions to avoid if they want to maintain portability. ADOdb provides date conversion functions so that you can create dates in any format and insert them into your SQL in the correct format for your database; which is one step toward database independent SQL.Some databases support the Limit phrase which first appeared in MySQL and is now part of SQL. ADOdb's SelectLimit( ) translates limit to different mechanisms for each database and can emulate limit for databases with no native limit equivalent. Translations will perform efficiently. Emulations may work slowly by returning too many rows then using only those that meet the limit.
ADOdb has variables that contain the correct SQL for a database for specific functions. For example, to check for a null value, null can be replaced with the ADOdb variable that contains the correct SQL definition for null and the check for null will work in every database.
ee also
*
ADOdb Lite
*PHP Data Objects External links
* [http://adodb.sourceforge.net/ ADOdb home page]
* [http://phplens.com/lens/adodb/ comparison of the database abstraction layers] , including ADOdb
Wikimedia Foundation. 2010.