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

Buy me a book

Buy me a book - Data Structures And Algorithm Analysis In C

XML RSS feed Articles » Oracle

PHP UK 2010: RDBMS in the social networks age

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server, Data structures    27 February 2010
Wrapup of the PHP UK Conference 2010. Uploaded slides of my talk "RDBMS in the social networks age" about graphs in the database.

Speaking at the PHP Barcelona conference 2009

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server    26 October 2009
Speaking at the PHP Barcelona Conference 2009. Talk: "Trees in the Database: Advanced Data Structures".

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

Database, PostgreSQL, Firebird SQL, Oracle, SQL Server, Tutorial, Data structures    7 September 2009
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).

Trees in the database: It sure ain't no CouchDB!

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server, Data structures    27 June 2009
Wrap-up of the Dutch PHP Conference, Amsterdam, 11-13 June 2009.

Speaking at the Dutch PHP Conference 2009

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server    10 April 2009
Speaking at the Dutch PHP Conference 2009. Talk: "Trees in the Database: Advanced Data Structures".

Database identifiers, quoting and case sensitivity

PHP, PEAR, PostgreSQL, Oracle    3 December 2008
Exploring database delimited identifiers and case sensitivity: the effect of quoting table and field names in the various DBMS.

Updated articles to extract META informations from databases

PHP, Database, PostgreSQL, Firebird SQL, Oracle, SQL Server, INFORMATION_SCHEMA    9 September 2008
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.

Book review: "PHP Oracle Web Development" by Yuli Vasiliev

PHP, PEAR, Database, Oracle, Book Review    17 November 2007
Review of the book "PHP Oracle Web Development" by Yuli Vasiliev (Packt Publishing). Book contents, highlights and impressions. A sample chapter is included.

Extracting META information from Oracle (INFORMATION_SCHEMA)

PHP, Database, Oracle, INFORMATION_SCHEMA    17 June 2007
Extracting META information from an Oracle database using the Oracle Data Dictionary views (INFORMATION_SCHEMA)

DBMS and charsets, a summary and a call for help

PHP, PEAR, Database, MySQL, PostgreSQL, Firebird SQL, Oracle, SQLite, Charset    28 September 2006
Some clarification about charset settings for the various DBMS (MySQL, PostgreSQL, Firebird/Interbase, Oracle, Sqlite) and a call for help for charset setting support in PEAR::MDB2.

Lorenzo Alberton

Lorenzo Alberton Lorenzo PHP5 ZCE - Zend Certified Engineer 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. Lorenzo Alberton's profile on LinkedIN Lorenzo Alberton - Sun Certified MySQL 5 Developer