WordPress and Drupal are two of the more popular open source content management systems in the world. WordPress is the most widely used and powers the Sites @ PSU platform. Drupal is the most powerful, flexible, lucrative and expensive CMS in the world.
Both are typically MySQL backed, have one click installers, and large communities of practice. We're going to setup a simple WordPress site and analyze some of the pros and cons of this CMS as well as dig into its data model and see how they structured things and why. We'll also discuss the controversial Gutenberg editor and how it messes with people'd data model / conception of a data model.
Drupal is used far less in general but has much bigger clients. It powers high scale top level properties like PSU.edu, MSNBC, the grammies and more. Drupal is heavily used by governments across the globe because of it's security, abstraction layers and community. We'll look at a Drupal database, though they are almost unreadable in complexity and scale relative to WordPress, and try to understand WHY Drupal is so powerful and popular among complex organizations.