ADOdb
 | This article may rely excessively on sources too closely associated with the subject, potentially preventing the article from being verifiable and neutral. (March 2020) |
| Original author(s) | John Lim |
|---|---|
| Developer(s) | Damien Regad, Mark Newnham |
| Stable release | 5.22.7
/ November 4, 2023 |
| Repository | github |
| Written in | PHP |
| Type | Database abstraction layer |
| License | BSD or LGPL |
| Website | adodb |
ADOdb is a database abstraction library for PHP, originally based on the same concept as Microsoft's ActiveX Data Objects. It allows developers to write applications in a 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.
Features
[edit]ADOdb supports the following databases: [1]
- Firebird
- IBM Db2
- Interbase
- Lightweight Directory Access Protocol (LDAP)
- Microsoft Access
- Microsoft SQL Server
- MySQL
- Oracle database
- PHP Data Objects (PDO)
- PostgreSQL
- SQLite
- generic ODBC
- MariaDB
Legacy, unsupported or obsolete drivers may still be found in older releases of ADOdb.[2]
In addition to the Database Abstraction Layer, ADOdb includes the following features:
- Schema management tools: a suite of tools to interrogate the attributes of tables, fields and indexes in databases as well as providing cross-database schema management including a full suite of XML based functions
- Date and time library: provides a drop-in replacement for PHP date functions, but provide access to dates outside the normal range of dates supported by normal PHP functions
- Session management tools: allows storing session data in a database table or as encrypted data
References
[edit]- ^ "ADOdb supported databases". ADOdb wiki. Retrieved 13 January 2020.
- ^ "Supported Databases [ADOdb]". adodb.org. Retrieved 2020-03-22.