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.
Design problems
URL Shortener
JuniorDesign a URL shortener like TinyURL or Bitly.
CachingLoad Balancing & Scaling
Unique ID Generator
JuniorDesign a distributed unique ID generation service like Twitter Snowflake.
Consistency & Trade-offs
Pastebin
JuniorDesign a Pastebin-style text snippet sharing service.
CachingLoad Balancing & Scaling
News Feed
Mid/SeniorDesign a social news feed like Instagram's or Facebook's home feed.
CachingQueues & Async Processing
Chat Messaging
Mid/SeniorDesign a real-time chat and messaging service like WhatsApp or Messenger.
Consistency & Trade-offsQueues & Async Processing
Video Streaming
Mid/SeniorDesign the video playback and delivery system for a streaming service like Netflix or YouTube.
CachingLoad Balancing & Scaling
File Sync
Mid/SeniorDesign a file sync and storage service like Dropbox or Google Drive.
Consistency & Trade-offsQueues & Async Processing
Maps & ETA
StaffDesign a maps routing and ETA service like Google Maps.
CachingLoad Balancing & Scaling
Ticketing System
Mid/SeniorDesign an event ticketing system like Ticketmaster.
Consistency & Trade-offsQueues & Async Processing
Payment Processing
StaffDesign a payment processing system like Stripe.
Consistency & Trade-offsQueues & Async Processing
Search Autocomplete
Mid/SeniorDesign a search autocomplete (typeahead) service.
CachingLoad Balancing & Scaling
Web Crawler
Mid/SeniorDesign a large-scale distributed web crawler.
CachingQueues & Async Processing
Ad Click Aggregator
StaffDesign a real-time ad click aggregation system.
Consistency & Trade-offsQueues & Async Processing
Recommendation System
StaffDesign a personalized recommendation system like Netflix's.
CachingQueues & Async Processing
Digital Wallet
JuniorDesign a stored-value digital wallet like Apple Cash or Paytm.
Consistency & Trade-offs
Ledger Service
Mid/SeniorDesign a double-entry ledger service for a fintech like Ramp or Wise.
Consistency & Trade-offsQueues & Async Processing
Peer-to-Peer Payments
Mid/SeniorDesign a peer-to-peer money transfer app like Venmo or Cash App.
Consistency & Trade-offsQueues & Async Processing
Package Tracking
Mid/SeniorDesign a package tracking system like FedEx, UPS, or Amazon's track package feature.
CachingQueues & Async Processing
Hotel Booking
JuniorDesign a hotel room booking system like Booking.com or Expedia.
CachingConsistency & Trade-offs
Like Counter
JuniorDesign the like counting system for a social app like Instagram or YouTube.
CachingConsistency & Trade-offs
Social Graph
Mid/SeniorDesign the follow graph service for a social network like Twitter or Instagram.
CachingConsistency & Trade-offs
Image Hosting
JuniorDesign an image hosting and delivery service like Imgur or Instagram.
CachingQueues & Async Processing
Watch History
JuniorDesign the watch history and continue watching feature for a service like Netflix.
CachingConsistency & Trade-offs
Shopping Cart
JuniorDesign the shopping cart service for a retailer like Amazon or Walmart.
CachingConsistency & Trade-offs
Product Catalog
Mid/SeniorDesign the product catalog service for a retailer like Walmart or a Shopify store.
CachingQueues & Async Processing
Order Checkout
Mid/SeniorDesign checkout and order placement for a store like Amazon or Instacart.
Consistency & Trade-offsQueues & Async Processing
Document Search
StaffDesign a document search service for a workspace like Google Drive or Confluence.
Consistency & Trade-offsQueues & Async Processing
Job Scheduler
Mid/SeniorDesign a distributed job scheduler like Quartz or Airflow's scheduler.
Consistency & Trade-offsQueues & Async Processing
Object Storage
StaffDesign an object storage service like Amazon S3 or Google Cloud Storage.
CachingConsistency & Trade-offs
Audit Log
JuniorDesign an audit log service for a multi-tenant SaaS product like Salesforce or GitHub.
Queues & Async Processing
Calendar Scheduling
JuniorDesign a calendar and meeting scheduling service like Google Calendar or Outlook.
CachingQueues & Async Processing
Access Control
Mid/SeniorDesign the access control system for a document sharing product like Google Drive.
CachingConsistency & Trade-offs
Distributed Key-Value Store
StaffDesign a durable, replicated key-value store like DynamoDB or Cassandra.
Consistency & Trade-offsLoad Balancing & Scaling
Multi-Region Active-Active
StaffDesign the multi-region active-active architecture for a global app like Shopify.
Consistency & Trade-offsLoad Balancing & Scaling
Recent Searches
JuniorDesign a recent searches list like the one Amazon or YouTube shows in an empty search box.
CachingConsistency & Trade-offs
Product Reviews
JuniorDesign a product ratings and reviews system like the one on Amazon or Yelp.
CachingConsistency & Trade-offs
Restaurant Menu
JuniorDesign the restaurant menu service behind a food delivery app like DoorDash or Uber Eats.
CachingConsistency & Trade-offs
Package Registry
JuniorDesign a package registry that serves library downloads, like npm or PyPI.
CachingConsistency & Trade-offs
Session Store
JuniorDesign 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