Similar to last scenario, a few options for how to get there
Building a 5 page site
Use PHPMyAdmin to demonstrate comprehending the relationship between the content and the database system
Using “query monitor” to trace how WP constructs or stores content
Scenario
That pesky manager Chris is back
He’s oddly stopped caring about databases or security for that matter and trusts the herd of open source devs to save him from botnets; he’s making you use WordPress
He has a more pressing concern though… how are we going to set up our authoring experience for content contributors?
He’s heard about 4 ways he thinks you COULD do it..
Chris wants you to play around with the different ways of creating content and make a selection
He wants you to keep in mind though that the team works on OTHER CMSs / projects as well so while portability of content isn’t paramount, it’s still to be considered
He knows there are advantages and trade offs of anything
He trusts you to make the call either way with evidence
Pick any of the editors mentioned this week
Create a simple 5 page site making the case for that editor
You’ll have to enable plugins or configure WordPress a bit and add content
There’s a ton of nice themes too, try and find one
Each site has the same requirements
The video has a variable option
Writing / Web site requirements
The 5 pages you need with content supplied
Introduction to the editor, support links, description
Pros and Cons of this editor (bullet list)
Alternatives, why you selected this one instead
How this system stores data. Explain how it manages HTML / complex body content (or doesn’t), screenshots and examples of the relation between a page and post_content is required
Embed of your Video submission for the week with option..
Video Option 1
Using Query monitor, identify all 4 CRUD operations
Demonstrate the relationship between the CMS executing user operations and the back end database storing, retrieving and modifying data based on user actions
This could be tied to the editor choice or just any actions in the site you’ve created for the written portion
Video Option 2
Create a multi-site instance of WordPress
This could be separate from your website or the website could be 1 of your sites in your multi-site
Explain table prefixing, and the pros / cons of this approach
Show the relationship between requesting a new site in the multi-site in the UI and the back end creating tables to match
Edit one of the site’s content and show the associated DB table content
Video Option 3
Using Query monitor in both sites, which performs better on a page that has similar content (creating a page with 2 paragraphs, 2 images and a Youtube video embedded)
If there’s little or no difference, state that
Finish with your opinion on which you’d rather have to explain to someone how to use
Submission
Create your 5 page WP/CP site + video
In the video mention the option you selected
Submit link to post in #lab7-wordpress channel on Slack
This is due by Sunday at 11:59pm
Rubric
Website is created using WordPress or ClassicPress (2pts)
Written content is accurate and explains DB relationship for saving a page of content (2 pts)
Demonstration of technique in video based on option (4pts)
Evaluation is contextualized based on which option you pick.
