MySource Matrix uses the PEAR DB library which is limited to PHP 4. MDB2 is PEAR's PHP 4/5 replacement for DB. Is Matrix moving to MDB2?
PDO is the PHP 5.1 universal database access class but is not compatible with older versions of PHP. ADOdb is the database access library used by most CMSs and PDO is a long way off matching ADOdb. MDB2 implements most of the ADOdb features and has some compatibility with DB, which makes MDB2 the logical successor to DB. Is there a roadmap for advancing Matrix to PHP 5?
DB access roadmap?
Peter
(P Moulding)
#1
gsherwood
(Greg Sherwood)
#2
MySource Matrix will not migrate to PHP5, MDB2 or PDO. However, MySource4 is written in PHP5 and uses PDO to provide support for MySQL, PostgreSQL, Oracle, MSSQL and DB2.
gsherwood
(Greg Sherwood)
#4
Yes.
We have removed the use of IN statements as much as possible to make this happen.
gsherwood
(Greg Sherwood)
#6
Squiz's position changed and PHP4 was discontinued so we had to move faster than we had hoped. 3.18 uses PHP5 and PDO for PostgreSQL. It still uses the OCI8 extension for Oracle though as the PDO driver has/had too many bugs.
To make the most of the opportunity, we ported the DB abstraction layer from MySource4 into Matrix so we had support for bind variables as well.