Lorenzo Alberton
Articles » Firebird SQL
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 FrameworkPHP 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
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
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
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
Extracting META information from Interbase/Firebird SQL (INFORMATION_SCHEMA)
Extracting META informations from Interbase/Firebird System Tables (INFORMATION_SCHEMA) Read article
Firebird 2 cheat sheet
Cheat sheet for the upcoming Firebird 2. A handy reference of the FB2 datatypes, an useful query reference and a list of the PHP Firebird/Interbase functions. Read article
DBMS and charsets, a summary and a call for help
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. Read article