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

Musings on some technical papers I read this weekend: Google Dremel, NoSQL comparison, Gossip Protocols

Some random comments on Dremel and a benchmark on Key-Value stores. How to evaluate technical papers and read between the lines.   Read article

3 September 2012

NoSQL Databases: What, When and Why (PHPUK2011)

Some considerations about NoSQL databases, and slides of my talk given at PHPUK 2011: "NoSQL Databases: What, When and Why".   Read article

27 February 2011

The Art of Scalability - DPC10 wrapup

A wrapup of the Dutch PHP Conference 2010. Uploaded slides of my talk "The Art of Scalability - Managing growth".   Read article

13 June 2010

PHP UK 2010: RDBMS in the social networks age

Wrapup of the PHP UK Conference 2010. Uploaded slides of my talk "RDBMS in the social networks age" about graphs in the database.   Read article

27 February 2010

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
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

Updated articles to extract META informations from databases

By popular request, I've updated my articles explaining how to retrieve meta data from your DBMS (Firebird SQL, PostgreSQL, Oracle, SQL Server). Have fun.   Read article

9 September 2008