Lorenzo Alberton

London, UK · Contact me ·

Articles

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

An update on my PEAR packages

PHP, PEAR

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

1 February 2007

Get involved in PEAR!

PHP, PEAR

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

15 November 2006

Firebird 2 cheat sheet

PHP, Database, Firebird SQL, 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

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

PHP, PEAR, Database, Tutorial

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

16 October 2006

PEAR::Pager Tutorials - Navigation with Pager and AJAX (or simple Javascript)

PHP, PEAR, JavaScript, AJAX, Tutorial

PEAR::Pager can generate javascript links and AJAX calls. Read how in this new Pager tutorial, examples are included. Read article

3 October 2006

DBMS and charsets, a summary and a call for help

PHP, PEAR, Database, MySQL, PostgreSQL, Firebird SQL, Oracle, SQLite, Charset

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 - Create pretty links with Pager and mod_rewrite

PHP, PEAR, mod_rewrite, Tutorial

How to tell PEAR::Pager about your links format and use it to generate mod_rewrite compatible links. Read article

19 September 2006

PEAR::Pager Tutorials - Paginate database results

PHP, PEAR, Database, Tutorial

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

8 September 2006

PEAR::Pager Tutorials

PHP, PEAR, Database, Tutorial

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

8 September 2006