Lorenzo Alberton
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 FrameworkProfiling 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
Speaking at the PHP Barcelona conference 2009
Speaking at the PHP Barcelona Conference 2009. Talk: "Trees in the Database: Advanced Data Structures". Read article
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
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
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
Trees in the database: It sure ain't no CouchDB!
Wrap-up of the Dutch PHP Conference, Amsterdam, 11-13 June 2009. Read article
Speaking at the Dutch PHP Conference 2009
Speaking at the Dutch PHP Conference 2009. Talk: "Trees in the Database: Advanced Data Structures". Read article
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
Book review: "TYPO3 Extension Development" by Dmitry Dulepov
A review of the book TYPO3 Extension Development" by Dmitry Dulepov, Packt Publishing Read article
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