Auto-increment doesn't survive sharding, and random UUIDs wreck your database's index. How do you mint billions of unique, roughly time-sortable 64-bit IDs across a fleet with no coordinator? This is the Snowflake design — bit for bit.
The canonical system-design interview, built end to end: how tiny.co/aB3xK9 becomes a database lookup in single-digit milliseconds — base62, key generation, the read-heavy cache, and the scale math that makes 7 characters last a century.
The Twitter/Instagram timeline, worked end to end. The whole system pivots on one decision — do you build a follower's feed when someone posts (push), or when they open the app (pull)? Toggle between them, watch the write and read cost flip, and see why one celebrity breaks the naive answer.