Mastering your data: An exploration of Drupal's database structure
crasx
One of the skills that all Drupal masters have in common is that they aren't afraid to roll up their sleeves and dive into the database. In this session we will step beyond the code into the inner structure of a Drupal database and discuss key ideas that will help you get oriented. This intermediate level track will give you the courage to log into the database to tackle the more complex data related problems that a Drupal developer might face.
Key ideas we will cover
-
An intimate view of how Drupal's database is designed
-
How Drupal's database design to the designs of Magento and Wordpress
-
A discussion of how you can sift through data and build complex queries, also a look at how views builds queries
-
A comparison of the design of common Drupal entities
-
How entity design can impact performance and how to properly index your entities
-
Optimizing entity structures and queries using query plans