Schema design for read-heavy workloads in MongoDB - Mini Project: Build & Apply

Schema Design for Read-Heavy Workloads in MongoDB

📖 Scenario: You are building a simple blog platform where many users read posts frequently, but writes (new posts or updates) happen less often. To make reading posts fast and efficient, you want to design a MongoDB schema optimized for read-heavy workloads.

🎯 Goal: Create a MongoDB schema that stores blog posts with embedded comments to optimize read performance. You will start by defining the initial data structure, add a configuration for maximum comments per post, implement the core logic to embed comments inside posts, and finally complete the schema with an index to speed up reads.

📋 What You'll Learn

Create a collection called posts with fields _id, title, content, and comments (an array).

Add a configuration variable max_comments to limit the number of comments stored per post.

Write a function add_comment(post, comment) that adds a comment to the comments array only if the number of comments is less than max_comments.

Create an index on the title field to speed up read queries by post title.

💡 Why This Matters

🌍 Real World

Many web applications have pages that are read far more often than updated. Embedding related data and indexing key fields helps make these reads fast and efficient.

💼 Career

Understanding schema design for read-heavy workloads is important for backend developers and database administrators to optimize performance and scalability in real-world applications.

1

Create the initial posts collection schema

Create a MongoDB document structure for a blog post with fields: _id (string), title (string), content (string), and an empty array comments. Assign this document to a variable called post.

MongoDB

post = {
    "_id": "post1",
    "title": "",
    "content": "",
    "comments": []
}
# Your code here

Need a hint?

Use a Python dictionary to represent the MongoDB document. Initialize comments as an empty list.

2

Add a configuration variable max_comments

Create a variable called max_comments and set it to 3. This will limit the number of comments stored per post.

MongoDB

post = {
    "_id": "post1",
    "title": "Introduction to MongoDB",
    "content": "MongoDB is a NoSQL database optimized for document storage.",
    "comments": []
}

# Your code here

Need a hint?

Just create a simple variable named max_comments and assign the number 3.

3

Write a function to add comments respecting max_comments

Write a function called add_comment(post, comment) that adds the comment string to the comments array inside post only if the number of comments is less than max_comments. Use len(post["comments"]) to check the count.

MongoDB

post = {
    "_id": "post1",
    "title": "Introduction to MongoDB",
    "content": "MongoDB is a NoSQL database optimized for document storage.",
    "comments": []
}

max_comments = 3

def add_comment(post, comment):
    # Your code here

Need a hint?

Use an if statement to check the length of post["comments"]. Append the comment only if the count is less than max_comments.

4

Create an index on the title field for faster reads

Write a MongoDB command to create an index on the title field of the posts collection. Assign this command to a variable called index_command. Use the format { "title": 1 } to specify ascending order.

MongoDB

post = {
    "_id": "post1",
    "title": "Introduction to MongoDB",
    "content": "MongoDB is a NoSQL database optimized for document storage.",
    "comments": []
}

max_comments = 3

def add_comment(post, comment):
    if len(post["comments"]) < max_comments:
        post["comments"].append(comment)

index_command = {}
# Your code here

Need a hint?

Use a dictionary with the key "title" and value 1 to indicate ascending index order.