ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:feature_comparison

Feature Comparison Matrix

ADOdb features, by Database Type

Check that the 'Verified' column is checked before relying on information

Driver Support

Tier 1 Support

Tier 1 Drivers are fully supported by members of the ADOdb project, and all contain the full feature list. New feature is available for all drivers on release of feature

Tier 2 Support

Tier 2 Drivers may not be supported by ADOdb project members, or may not contain features (in particular Data Dictionary feature). Drivers may be associated with deprecated or removed PHP drivers.

Compatibility

Access Firebird Frontbase Interbase IBM DB2 Informix Microsoft SQL Server MySQL Netezza ODBC Oracle PostgreSQL SAP DB SQLite
Verified No No No Yes No No No No No No No No No
Sequences Yes Yes Yes1) Emulated Emulated Yes Yes
ADODB_FETCH_BOTH No Yes Yes Yes
Transactions No Yes Yes Yes Yes Yes Yes2) Yes Yes Yes Yes Yes Yes
Record Counting Emulated Emulated
selectLimit() Emulated3) Yes Yes Yes
Date Offset Functions No
MetaTables Masking No No No No No Yes Yes Yes Yes Yes Yes Yes Yes
rowLock row locking No
rowLock column locking No
setCharSet4) No No No No No No Yes No No No Yes No No
setConnectionParameter() Yes Yes Yes Yes
Blob Handling No No No Yes No Yes No No No No No No No
Stored Procedures No No No Yes No Yes No No No Yes No No No
Performance Monitoring No No No Yes Yes Yes Yes No No Yes Yes No No
1)
Emulated in Server 2008 and lower
2)
Transactional Tables Only
3)
Native if query constructed so that TOP n records can be used
v5/database/feature_comparison.txt · Last modified: 2019/12/28 03:37 by mnewnham