6. Relational Databases

Drupal relies on an SQL database to store information, and currently supports MySQL and PostgreSQL. Properly using Views requires an understanding of how the database stores data, how the data is related across various tables, and how Drupal works with the database to retrieve data.

This chapter is directed toward newer users and programmers. It covers some of the basics of relational databases: how data is stored, how it goes in, how it comes out, and how pieces are related to each other—most specifically as they relate to using Views later on.

Drupal, SQL, and the Emergence of Views

Drupal, out of the box, requires a database for everything it does. Drupal supports the use of MySQL or PostgreSQL as an install-ready ...

Get Drupal’s Building Blocks: Quickly Building Web Sites with CCK, Views, and Panels now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.