This site is archived.

Drupal Databases: The Next Generation

Crell's picture
Submitted by Crell on Sat, 07/05/2008 - 19:49.

Session recording

Attached files

Session time: 
08/29/2008 - 09:00 - 08/29/2008 - 10:30
Conference booklet summary and bio
Article for conference booklet: 
Drupal's database layer has undergone a major overhaul in Drupal 7 to take advantage of new and powerful features in PHP 5. The new system includes over a dozen new features, from a query builder in core to support for Master/slave replication. As with most major overhauls, however, that means API changes. This session will cover the challenges of database abstraction, Drupal's approach, and how to fully leverage the new system in your own code and sites.
Bios for conference booklet: 
Larry Garfield is the Senior Lead of Programming Services at, a Drupal consulting firm in Chicago, USA. He has been developing PHP for nearly a decade and has been actively involved in Drupal since 2005. He currently serves on the Drupal Association Board of Directors and spearheaded the Drupal 7 database overhaul, among other projects. Larry was also a founding organizer of the GoPHP5 effort.


Drupal 7 will feature a newly rewritten database layer providing improved database abstraction, portability, and scalability features. This session will cover the thinking and architecture behind the new layer, with an eye toward understanding how it fits into the larger scheme of high-performance Drupal sites. There will be some discussion of code, as well as words of advice for others looking to revamp one of Drupal's core systems.

There will be some code in this session, but you should not need to be a hard-core coder to follow it. This session will also serve as a lead-in to this code track session, which is aimed more at programmers.


* Database abstraction: Why it's hard and even an unsolvable problem.
* The old Drupal approach, and why it's not good.
* The new Drupal approach, and why it's awesome.
* Leveraging the database on your own deployments.
* Request for feedback on some of the more big-iron-targeted parts of the new feature set.
* Recommendations for other core developers on how to (not) revamp Drupal subsystems.


After attending this session, you should have a good idea of ways to leverage the new, modernized database system for your own sites as well as how to go about making major changes to Drupal's infrastructure.


Knowing the basics of SQL servers before attending would be a good idea, for context.