System Design Interview, System Design Concepts, System Design, Design Tinyurl, Design Bitly.
schema could be simple: a primary key for the short URL id and fields for the long URL and possibly creation metadata. { "shortUrlId": "3ad32p9", "longUrl": "https://example.com/very-long-url", "creationDate": "2024-03-08T12:00:00Z", "userId": "user123", "clicks": 1023, "metadata": { "title":