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

Profiling PHP Applications with XHProf

An introduction to PHP Profiling using XHProf, and some techniques on how to get the most out of your application.   Read article

1 December 2009

Speaking at the PHP Barcelona conference 2009

Speaking at the PHP Barcelona Conference 2009. Talk: "Trees in the Database: Advanced Data Structures".   Read article

26 October 2009

New article: Graphs in the database, SQL meets social networks

Graphs in the database: how to store a graph data structure in a DBMS, and answer the most common queries typical of social networks, like "You might also know" or "You might also like", or "How you are connected to XYZ" (degrees of separation).   Read article

7 September 2009

Graphs in the database: SQL meets social networks

How to store a graph data structure in a DBMS, and query it to solve many of the problems of social networks.   Read article

7 September 2009

Create a video preview as animated GIF with FFmpeg and PHP SPL

Extract frames from a movie and create a preview as animated GIF, using PHP, SPL, Imagick and FFmpeg.   Read article

31 August 2009
27 June 2009

Speaking at the Dutch PHP Conference 2009

Speaking at the Dutch PHP Conference 2009. Talk: "Trees in the Database: Advanced Data Structures".   Read article

10 April 2009

Zend Framework, mod_rewrite and public dir in shared hosting

A quick tip on how to deal with Zend Framework directory structure and the public document root directory in most shared hosting accounts, using mod_rewrite and an .htaccess file.   Read article

15 February 2009

Book review: "TYPO3 Extension Development" by Dmitry Dulepov

A review of the book TYPO3 Extension Development" by Dmitry Dulepov, Packt Publishing   Read article

8 January 2009

Database identifiers, quoting and case sensitivity

Exploring database delimited identifiers and case sensitivity: the effect of quoting table and field names in the various DBMS.   Read article

3 December 2008