id-generation 2 What Sharding Takes Away: Joins, Transactions, Unique Constraints, and IDs Nov 2, 2026 Design a URL Shortener: The Gotchas Hiding Inside the Easiest System Design Question Sep 18, 2026