#####   ######  #####    ###    #   #  ###  #   #  ######
##  ##  ##      ##  ##  ## ##   #   #   #   #   #  ##
#####   ####    #####   #   #   #   #   #   #   #  ####
##  #   ##      ##      ## ##    # #    #    # #   ##
##   #  ######  ##       ###      #    ###    #    ######

$ curl repovive.com/roadmaps/system-design-interview-prep/design-practice-easy/url-shortener-design

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░███████████████████████████████████████████████████████████████████████████████████████████████████

#####   ######  #####    ###    #   #  ###  #   #  ######
##  ##  ##      ##  ##  ## ##   #   #   #   #   #  ##
#####   ####    #####   #   #   #   #   #   #   #  ####
##  #   ##      ##      ## ##    # #    #    # #   ##
##   #  ######  ##       ###      #    ###    #    ######

$ curl repovive.com/roadmaps/system-design-interview-prep/design-practice-easy/url-shortener-design

Repovive

URL Shortener - Design - Design Practice - Easy | System Design Interview Prep | Repovive

Repovive.

System Design Interview Prep22 sections · 691 units23h total

Open in Course

URL Shortener - Design

Architecture

High-level design:

Load balancer → Application servers → Database
Cache (Redis) between app servers and database

Database schema:

url_mappings: short_code (PK), long_url, created_at, expires_at

Short code generation options:

$1.$ Hash the URL, take first $6$ chars. Collision handling needed.

$2.$ Pre-generate codes, assign from a pool. No collisions.

$3.$ Distributed ID generator, convert to base62.

Flow: Client → LB → App Server → Check cache → If miss, check DB → Return redirect.