Design a Twitter-like microblogging platform

Design a Twitter-like Platform

Core interactions

1. Create/delete tweets
2. View your own tweets
3. View tweets for a given account
4. Follow other accounts
5. Like and unlike tweets (can like tweets from non-followed accounts)
6. View list of accounts that follow you
7. View list of accounts you are following

Dashboard (home feed)

Build a paginated dashboard that shows a curated list of the top X tweets for each user.

Prioritization signals (examples)

The ranking/curation should incorporate signals such as:

• Tweets from accounts you follow
• Tweets with many likes
• Tweets with many recent likes
• Recently created tweets
• Tweets from accounts you recently followed
• Tweets from accounts you recently viewed
• Tweets from accounts you view often

Suggested entities

• tweets : tweet_id, text, account_id, created_at
• follow : follow_from_account_id, follow_to_account_id, created_at
• likes : tweet_id, liked_from_account_id, created_at
• accounts : account_id, created_at

Design APIs, storage, and the feed generation approach. Address scalability, consistency, and pagination.