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

• Kafka proposed as Apache incubator project
• NoSQL Databases: What, When and Why (PHPUK2011)
• PHPNW10 slides and new job!
• 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

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!

---

Follow Lorenzo on Twitter

---

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.

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 Framework