Tags
AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Imagick, INFORMATION_SCHEMA, JavaScript, Linux, Message Queues, mod_rewrite, MySQL, NoSQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend FrameworkBuy me a book
Articles
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 - Create pretty links with Pager and mod_rewrite
How to tell PEAR::Pager about your links format and use it to generate mod_rewrite compatible links.
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.
Secure PHP installation on unix/linux systems
Simple guide to a more secure PHP installation on unix/linux systems.
Extracting META information from PostgreSQL (INFORMATION_SCHEMA)
Extracting META information from a PostgreSQL database using the INFORMATION_SCHEMA views and the system catalogs (pg_class, pg_user, pg_view)
PHP PDO_Firebird status
A quick roundup of the PHP PDO_Firebird driver. Test of its current status: what works and what doesn't.
HowTo: Install Firebird/Interbase with PHP on Windows. A step-by-step tutorial.
A step-by-step tutorial to install Firebird SQL on Windows and enabling its usage in PHP.
Lorenzo Alberton
Lorenzo 
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.
