From Wikipedia, the free encyclopedia
Jump to: navigation, search
Original author(s) John Lim
Stable release 5.19 / April 30, 2014 (2014-04-30)
Written in PHP, Python
Type Database abstraction library
License BSD / LGPL

ADOdb is a database abstraction library for PHP (there is also an unmaintained Python version[1]) based on the same concept as Microsoft's ActiveX Data Objects. It allows developers to write applications in a fairly consistent way regardless of the underlying database system storing the information. The advantage is that the database system can be changed without re-writing every call to it in the application.

Supported Database Systems[edit]

ADOdb supports[2][3] the following databases:

ADOdb uses SQL. Since each database system 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 system independent SQL.

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.

See also[edit]


  1. ^ "ADOdb". SourceForge. Retrieved 8 September 2015. 
  2. ^ Supported Databases - Database Abstraction Library for PHP ADOdb Library for PHP Manual
  3. ^ Supported Databases - Database Abstraction Library for Python - ADOdb Library for Python Manual

External links[edit]