Lorenzo Alberton

London, UK   ·   Contact me   ·  

Articles » Database


Filter articles by topic

AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Hadoop, Imagick, INFORMATION_SCHEMA, JavaScript, Kafka, Linux, Message Queues, mod_rewrite, Monitoring, MySQL, NoSQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework

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

12 March 2007

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.   Read article

8 March 2007

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

20 February 2007

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.   Read article

6 November 2006

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.   Read article

6 November 2006

PEAR::Pager Tutorials - Article Pagination and Navigation

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

16 October 2006

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.   Read article

28 September 2006

PEAR::Pager Tutorials - Paginate database results

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

8 September 2006

PEAR::Pager Tutorials

New series of tutorials on PEAR::Pager.   Read article

8 September 2006

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.   Read article

6 June 2006