Gonzalo Ayuso: Combining Zend Framework2 and Symfony2 components with Composer to build PHP projects
Zend Framework 2 is finally stable. I must admit that I'm not a big fan of ZF (or even Symfony2) as a full stack framework. I normally prefer to use micro frameworks, but those two frameworks (ZF2 and SF2) are great as component libraries. Today we are going to build a simple console application (using symfony/console component) to list the database tables (using zendframework/zend-db's Metadata).
He starts with the information you'll need to put into your "composer.json" file to get the needed packages (and set up the autoloader a bit). Included in the post is the code to create his "SchemeCommand" class to make the new CLI command, one that connects to a database and echos out the metadata about the given table. A unit test is also included.