Database Scaling System Design Questions

39 design prompts lean on database scaling. Each one runs on a whiteboard canvas with AI feedback graded against a hidden rubric.

New to database scaling? There's a 5-lesson interactive course (~52 min) with animated architectures and runnable simulations. Learn the concept first →

Design problems

URL Shortener

Junior

Design a URL shortener like TinyURL or Bitly.

CachingLoad Balancing & Scaling

Unique ID Generator

Junior

Design a distributed unique ID generation service like Twitter Snowflake.

Consistency & Trade-offs

Pastebin

Junior

Design a Pastebin-style text snippet sharing service.

CachingLoad Balancing & Scaling

News Feed

Mid/Senior

Design a social news feed like Instagram's or Facebook's home feed.

CachingQueues & Async Processing

Chat Messaging

Mid/Senior

Design a real-time chat and messaging service like WhatsApp or Messenger.

Consistency & Trade-offsQueues & Async Processing

Video Streaming

Mid/Senior

Design the video playback and delivery system for a streaming service like Netflix or YouTube.

CachingLoad Balancing & Scaling

File Sync

Mid/Senior

Design a file sync and storage service like Dropbox or Google Drive.

Consistency & Trade-offsQueues & Async Processing

Maps & ETA

Staff

Design a maps routing and ETA service like Google Maps.

CachingLoad Balancing & Scaling

Ticketing System

Mid/Senior

Design an event ticketing system like Ticketmaster.

Consistency & Trade-offsQueues & Async Processing

Payment Processing

Staff

Design a payment processing system like Stripe.

Consistency & Trade-offsQueues & Async Processing

Search Autocomplete

Mid/Senior

Design a search autocomplete (typeahead) service.

CachingLoad Balancing & Scaling

Web Crawler

Mid/Senior

Design a large-scale distributed web crawler.

CachingQueues & Async Processing

Ad Click Aggregator

Staff

Design a real-time ad click aggregation system.

Consistency & Trade-offsQueues & Async Processing

Recommendation System

Staff

Design a personalized recommendation system like Netflix's.

CachingQueues & Async Processing

Digital Wallet

Junior

Design a stored-value digital wallet like Apple Cash or Paytm.

Consistency & Trade-offs

Ledger Service

Mid/Senior

Design a double-entry ledger service for a fintech like Ramp or Wise.

Consistency & Trade-offsQueues & Async Processing

Peer-to-Peer Payments

Mid/Senior

Design a peer-to-peer money transfer app like Venmo or Cash App.

Consistency & Trade-offsQueues & Async Processing

Package Tracking

Mid/Senior

Design a package tracking system like FedEx, UPS, or Amazon's track package feature.

CachingQueues & Async Processing

Hotel Booking

Junior

Design a hotel room booking system like Booking.com or Expedia.

CachingConsistency & Trade-offs

Like Counter

Junior

Design the like counting system for a social app like Instagram or YouTube.

CachingConsistency & Trade-offs

Social Graph

Mid/Senior

Design the follow graph service for a social network like Twitter or Instagram.

CachingConsistency & Trade-offs

Image Hosting

Junior

Design an image hosting and delivery service like Imgur or Instagram.

CachingQueues & Async Processing

Watch History

Junior

Design the watch history and continue watching feature for a service like Netflix.

CachingConsistency & Trade-offs

Shopping Cart

Junior

Design the shopping cart service for a retailer like Amazon or Walmart.

CachingConsistency & Trade-offs

Product Catalog

Mid/Senior

Design the product catalog service for a retailer like Walmart or a Shopify store.

CachingQueues & Async Processing

Order Checkout

Mid/Senior

Design checkout and order placement for a store like Amazon or Instacart.

Consistency & Trade-offsQueues & Async Processing

Document Search

Staff

Design a document search service for a workspace like Google Drive or Confluence.

Consistency & Trade-offsQueues & Async Processing

Job Scheduler

Mid/Senior

Design a distributed job scheduler like Quartz or Airflow's scheduler.

Consistency & Trade-offsQueues & Async Processing

Object Storage

Staff

Design an object storage service like Amazon S3 or Google Cloud Storage.

CachingConsistency & Trade-offs

Audit Log

Junior

Design an audit log service for a multi-tenant SaaS product like Salesforce or GitHub.

Queues & Async Processing

Calendar Scheduling

Junior

Design a calendar and meeting scheduling service like Google Calendar or Outlook.

CachingQueues & Async Processing

Access Control

Mid/Senior

Design the access control system for a document sharing product like Google Drive.

CachingConsistency & Trade-offs

Distributed Key-Value Store

Staff

Design a durable, replicated key-value store like DynamoDB or Cassandra.

Consistency & Trade-offsLoad Balancing & Scaling

Multi-Region Active-Active

Staff

Design the multi-region active-active architecture for a global app like Shopify.

Consistency & Trade-offsLoad Balancing & Scaling

Recent Searches

Junior

Design a recent searches list like the one Amazon or YouTube shows in an empty search box.

CachingConsistency & Trade-offs

Product Reviews

Junior

Design a product ratings and reviews system like the one on Amazon or Yelp.

CachingConsistency & Trade-offs

Restaurant Menu

Junior

Design the restaurant menu service behind a food delivery app like DoorDash or Uber Eats.

CachingConsistency & Trade-offs

Package Registry

Junior

Design a package registry that serves library downloads, like npm or PyPI.

CachingConsistency & Trade-offs

Session Store

Junior

Design the login session store for a large web application like GitHub.

CachingConsistency & Trade-offs

Want the pressure version? Any of these can run as a live 45-minute design interview with follow-up questions and a verdict. Set up a design interview