I've finally committed the last pieces of code to implement full FOREIGN KEY support in the MDB2 Manager and Reverse modules. Please fetch the CVS version of the package and test it.

Zürich, PEAR updates and MDB2 Oracle development

Some updates on recent MDB2 developement: FOREIGN KEY support in the Manager and Reverse modules, etc. Also: updated SQL technical articles on INFORMATION_SCHEMA for Firebird, PostgreSQL, SQL Server and Oracle.

Extracting META information from an Oracle database using the Oracle Data Dictionary views (INFORMATION_SCHEMA)

A new stable release of MDB2 is out. Enjoy!

A new stable release of MDB2 is out. Enjoy!

How to retrieve META information from Microsoft SQL Server, using the INFORMATION_SCHEMA, with system tables (sysobjects, sysindexkeys, sysindexes, syscolumns, systypes, etc) and/or with system stored procedures (T-SQL).

Since I keep getting emails asking for help with PEAR::Pager, here's a couple of new examples about the most requested features: 1) how to use Pager with a template engine like Smarty; 2) how to use Pager_Wrapper to paginate database results and display them using AJAX.

An update about some of the PEAR packages I maintain: [M]DB_QueryTool, Mail_Queue, MDB2, Translation2.

An overview of the many ways to get involved in PEAR, and a few concrete suggestions.