XML RSS feed Articles » Database

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

Firebird 2 cheat sheet

Cheat sheet for the upcoming Firebird 2. A handy reference of the FB2 datatypes, an useful query reference and a list of the PHP Firebird/Interbase functions.

PostgreSQL cheat sheet

Cheat sheet for PostgreSQL 8. A handy reference of the PostgreSQL datatypes, an useful query reference (with an eye on the INFORMATION_SCHEMA tables) and a list of the internal PostgreSQL functions.

PEAR::Pager Tutorials - Article Pagination and Navigation

How to navigate through the paragraphs of a long article with PEAR::Pager.

DBMS and charsets, a summary and a call for help

Some clarification about charset settings for the various DBMS (MySQL, PostgreSQL, Firebird/Interbase, Oracle, Sqlite) and a call for help for charset setting support in PEAR::MDB2.

PEAR::Pager Tutorials - Paginate database results

Paginate database results with PEAR::Pager, in an efficient way.

PEAR::Pager Tutorials

New series of tutorials on PEAR::Pager.

Read-only db access to prevent SQL injection attacks

An idea for safer db applications: use read-only db access wherever possible. Use GRANT to create an user with read-only rights, and use it to prevent SQL injection attacks.
« Previous   1   2   3   4   Next »

Lorenzo Alberton

Lorenzo Alberton Lorenzo has been working with large enterprise UK companies for the past 10+ years and is currently CTO at DataSift. He's an international conference speaker and a long-time contributor to many open source projects. Lorenzo Alberton's profile on GitHub Lorenzo Alberton's profile on LinkedIN View Lorenzo Alberton's profile on PHP PEAR
View Lorenzo Alberton's Twitter stream Lorenzo Alberton - Sun Certified MySQL 5 Developer PHP5 ZCE - Zend Certified Engineer