Lorenzo Alberton

At a glance

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.

Print     Permalink

Latest articles

• The Art of Scalability - DPC10 wrapup
• PHP UK 2010: RDBMS in the social networks age
• Profiling PHP applications with XHProf: the path to scalability
• Speaking at the PHP Barcelona conference 2009
• New article: Graphs in the database, SQL meets social networks

Updated articles to extract META informations from databases

It looks like my articles on how to extract META information from your favorite DBMS (with INFORMATION_SCHEMA or system tables) are still very popular, and I keep receiving a lot of mails on how to write similar queries to retrieve some obscure details about constraints, indices, stored procedures, etc.

For the greater good of mankind, and to reduce the flow of emails to my Inbox a bit ;-), I updated the articles and included new queries:

• Interbase/Firebird INFORMATION_SCHEMA
• Oracle INFORMATION_SCHEMA
• PostgreSQL INFORMATION_SCHEMA
• SQL Server INFORMATION_SCHEMA

Enjoy!

Lorenzo Alberton

Lorenzo works as a Consultant / Software Engineer / Technical Team Leader at Ibuildings, always busy with many cool clients. He's a long-time contributor to many open source projects.

Tags

AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Imagick, INFORMATION_SCHEMA, JavaScript, Linux, mod_rewrite, MySQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework