How to build Twitter

A post working in progress

Specs:
– heavy write
– can scale over time
– real time activity feed
– use SQL

Query pattern:
– Post a tweet
– Read a timeline

Optimization one:
– precompute timeline for users, a.k.a. sacrifice space for speed

Optimization two:

Advertisements
Standard