Today, Zend released a new version zend-db 2.9.0! This is Zend's first new feature release in over 18 months, and contains 7 bug fixes, 6 new features, numerous unit test additions, and many documentation improvements.
zend-db is an important component of many PHP projects, and we know that its support is crucial for many people. As such, we allocated a number of weeks to triaging the various open issues and patches (more than 50) to ensure we would provide a stable release.
ADDED
- Added
AFTERsupport inALTER TABLEsyntax for MySQL. - Added support for empty values set with the
INpredicate. - Added support for dash characters in MySQL identifiers.
- Added support for implementing an error handler when used with
db2_prepare. - Added support for
LIMIT OFFSETfor db2. - Added the
versionDSN parameter for the pdo_dblib extension.
FIXED
- Fixes whitespace issues in
ORDER BYsyntax. - Fixes how parameters are bound to statements in the PDO adapter. PDO has a restriction on parameter names of
[0-9a-zA-Z_]; as such, the driver now hashes parameter names usingmd5()in order to ensure compatibility with other drivers. - Fixes SSL support in the mysqli adapter.
- Fixes an edge case when using
ResultSetwith array values (versus objects). - Fixes how the Firebird adapter attempts to retrieve the last generated value so as to prevent exceptions being raised.
- Provides fixes to enable usage of the component with PHP 7.2.
We also dropped support for PHP 5.5 (EOL last year) and HHVM; zend-db 2.9 and above now only support PHP 5.6 and PHP 7+ releases.
FUTURE OF ZEND-DB
We are planning a 3.0 release of zend-db sometime in 2018. This new major version will contain new features such as extended DDL support for different database vendors (currently, most support targets MySQL), and support for SEQUENCE. Additionally, that release will drop support for PHP versions older than 7.1.
If you want to contribute to zend-db, you are more than welcome! Read the Zend Framework contribution guide for more information.