XML RSS feed Articles

PEAR MDB2 2.5.0a1 released

A new alpha release of MDB2 is out. Please test the new FOREIGN KEY support, and report any issue you may experience before a stable release. Enjoy!

PEAR MDB2: FOREIGN KEY support is complete!

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.

Catching up - July 2007

Z├╝rich, PEAR updates and MDB2 Oracle development

PEAR MDB2 updates (FOREIGN KEY support!)

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 Oracle (INFORMATION_SCHEMA)

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

PEAR MDB2 2.4.1 released

A new stable release of MDB2 is out. Enjoy!

PEAR MDB2 2.4.0 released

A new stable release of MDB2 is out. Enjoy!

Extracting META information from SQL Server (INFORMATION_SCHEMA)

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).

PEAR::Pager Tutorials - Use Pager with Smarty. Use Pager_Wrapper with AJAX

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.

PostgreSQL table audit

PostgreSQL table audit: a tutorial featuring a working example with triggers and a PL/TCL function. Or: for once in a while, PHP is not the right tool ;-)
« Previous   1   2   3   4   5   6   Next »

Lorenzo Alberton

Lorenzo Alberton Lorenzo PHP5 ZCE - Zend Certified Engineer has been working with large enterprise UK companies for the past years and is now Chief Tech Architect at DataSift. He's an international conference speaker and a long-time contributor to many open source projects. Lorenzo Alberton's profile on LinkedIN View Lorenzo Alberton's Twitter stream

Lorenzo Alberton - Sun Certified MySQL 5 Developer