ADOdb
ADOdb
http://adodb.sourceforge.net/
ADOdb is a database abstraction library for PHP. The PHP version currently supports an amazing number of databases, thanks to the wonderful ADOdb community: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP drivers are community contributions. Some reasons why ADOdb is popular include:
- Designed for speed. It is probably the fastest free software database abstraction library available for PHP. See benchmarks.
- Provides extensive portability support such as date and type-handling and portable schema creation. See portable sql tips
- Support many enterprise features such as database backed sessions (with session expiry notification), SQL code generation, pivot tables, SELECT LIMIT emulation for all databases, performance monitoring.
- Easy to learn.
- Extensive QA, every release is unit-tested on Access, MySQL, PostgreSQL, MS SQL, Oracle 9.
- Mature, continuously developed since August 2000. Has a large community of users.
- Powerful Active Record support. See docs.
- Very reasonable licensing terms (BSD). This means that you can incorporate (and even compile) it into your software applications royalty-free without asking the author's permission, provided you include license.txt in your release.
Documentation
http://phplens.com/lens/adodb/docs-active-record.htm and http://phplens.com/lens/adodb/docs-adodb.htm and http://phplens.com/lens/adodb/docs-perf.htm and http://phplens.com/lens/adodb/docs-session.htm
Related Projects
Licensing
| License | Verified by | Verified on | Notes |
|---|---|---|---|
| BSD 3Clause | Kelly Hopkins | 10 February 2009 | |
| LGPLv2.1 | Kelly Hopkins | 10 February 2009 |
Leaders and contributors
| Contact(s) | Role |
|---|---|
 john Lim | Maintainer |
Resources and communication
| Audience | Resource type | URI |
|---|---|---|
| Developer | Download | |
| Developer | Homepage | http://sourceforge.net/projects/adodb/ |
| General | Forum |
Software prerequisites
This entry (in part or in whole) was last reviewed on 10 February 2009.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.
The copyright and license notices on this page only apply to the text on this page. Any software described in this text has its own copyright notice and license, which can usually be found in the distribution itself.