Database Scaling System Design Questions
14 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
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