Bitweaver - ADOdb

Created by: Lester Caine, Last modification: 25 August 2025

Main source for the ADOdb library which has been forked to lsces/ADOdb. This is currently based off build 5.22.8 and needs to be synced to 5.22.10 at least. The problem is that it is throwing PHP8.4 warning messages and I would rather fix those than simply hide them.

Home page: https://adodb.org/

Introduction

PHP's database access functions are not standardized. This creates a need for a database class library to hide the differences between the different databases (encapsulate the differences) so we can easily switch databases.

The library currently supports MySQL, Firebird & Interbase, PostgreSQL, SQLite3, Oracle, Microsoft SQL Server, Foxpro ODBC, Access ODBC, Informix, DB2, Sybase, Sybase SQL Anywhere, generic ODBC and Microsoft's ADO.

I'm currently using the Firebird PDO driver into PHP, but ADOdb simply translates it's generic calls to the right format. Having been involved with the discussions on the creating of the PDO family, one proposal even at that time was that we just adopt ADOdb back then. Today PDO still does not have all the capability that ADOdb provides particularly in the area of mata data management and so it is still the best base for cross databse support. The generic Firebird driver was pulled from general distribution with PHP several versions back, but we carried on supplying it outside the general distribution. Today there is a little fun with now three competing driver builds. There are a lot of old articles on the lsces.uk site in relation to firebird and I need to get a clean current set of notes to dovetail in with the bitweaver framework. The fun sorting what current driver to use is covered on that site.

That everything is now working with Firebird 5 just shows how stable the driver interface has been over the years and it was only really political actions that caused it's move to PECL before PHP7.4.0.