System Design: How to design Twitter? Interview question at Facebook, Google, Microsoft

Here is the link.

Core features - focus on them first


1. Tweeting
2. Timeline
Two things: your own timeline
- User
- Home
3. Following

Naive solution first

Relational database:
User table, tweets table

Tweets table with three columns:

ID
Content
user

User table

ID
Name

We care about more availability, little less about consistency in small time frame.

Optimized solution