zend-db is one the oldest and largest libraries in the Zend Framework family. It’s designed as an abstraction for SQL databases, supporting MySQL, PgSQL, PDO, IBM DB2, Oracle, Microsoft SQL Server, and more.
However, The code base is quite old. It was originally developed for PHP 5, and I think it’s time to move it to PHP 7.1 or 7.2. We are working on some PRs and we plan to have a 2.10 release very soon. We would like also to plan a 3.0.0 release. The first idea for 3.0.0 is to use type hints and type declarations with
strict_mode enabled. This will simplify implementation, and solve a number of current issues (see #330 as example).
The second idea is to split each database adapter to its own repository, such as zend-db-mysql, zend-db-pdo, etc. This will simplify testing and code maintenance, much as splitting ZF into its component repositories did, or as the planned split of zend-cache will.
The third idea (at the moment) is to merge new features as reported in the 3.0.0 milestone.
Last but not least, we need to improve the unit tests and integration tests. Right now, we have about 49% code coverage, and this is not an acceptable value for a critical library like zend-db. We would like also to improve the integration tests using Docker.
What other feedback or features would you like to see in zend-db 3.0.0?