ADOdb
{{Distinguish|ActiveX Data Objects}}
{{Third-party|date=March 2020}}
{{Infobox software
| name = ADOdb
| author = John Lim
| developer = Damien Regad, Mark Newnham
| released =
| latest release version = 5.22.7
| latest release date = {{release date|2023|11|04}}
| latest preview version =
| latest preview date =
| repo = {{URL|github.com/ADOdb/ADOdb}}
| programming language = PHP
| genre = Database abstraction layer
| website = {{url|adodb.org}}
}}
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
ADOdb supports the following databases: {{cite web |title=ADOdb supported databases |url=https://adodb.org/dokuwiki/doku.php?id=v5:database:supported |website=ADOdb wiki |accessdate=13 January 2020}}
- 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.{{cite web|accessdate=2020-03-22|title=Supported Databases [ADOdb]|url=https://adodb.org/dokuwiki/doku.php?id=v5:database:supported#unsupported_drivers|website=adodb.org}}
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
{{Reflist}}
External links
- {{Official website|adodb.org}}
- [https://sourceforge.net/projects/adodb SourceForge project page]