RETURN TO SYSTEM DESIGN VAULT (55)BLUEPRINT #45 // Medium
#45MediumMedia Streaming & Storage

Develop a Photo Sharing Platform like Flickr or Google Photos

ASKED IN INTERVIEWS AT:GoogleDoorDashAmazonUber

EXECUTIVE SUMMARY & PROBLEM STATEMENT

Design a personal photo cloud storage platform featuring asynchronous thumbnail generation, EXIF metadata extraction, search by album/tag, and automated deduplication.

SCALE ESTIMATION & TRAFFIC ENVELOPE

DAILY ACTIVE USERS / TPS100 Million users uploading 200 Million photos daily
READ / WRITE TRAFFIC RATIO10:1 read/view to upload
5-YEAR STORAGE CAPACITY1 Petabyte of photos uploaded per day

FUNCTIONAL REQUIREMENTS

  • [1]Upload original photos from mobile devices
  • [2]Auto-generate thumbnails and previews
  • [3]Search photos by date, location, and tags

NON-FUNCTIONAL REQUIREMENTS

  • •Zero data corruption or loss of original files
  • •Instant photo grid scrolling with responsive thumbnails
  • •Cost-effective cold storage archiving

CORE ARCHITECTURAL COMPONENTS

Direct-to-S3 Upload (Presigned URLs)
Image Worker Queue (SQS/Lambda)
PostgreSQL Metadata Store
CloudFront CDN
AWS S3 Glacier Archive Policy

DATA SCHEMA & PERSISTENCE

Photos: photo_id, user_id, s3_original_key, s3_thumb_key, taken_at, lat, lng, phash

DISTRIBUTED TRADE-OFFS & FAILURE MODES

  • ⟡Direct client upload to S3 via presigned URLs bypasses application backend servers, saving 90% of web server network bandwidth.