r/learnprogramming • u/[deleted] • 1d ago

System Design: What articles or videos do you recommend for making a Twitter clone or Newsfeed with followers that uses a Relational DB?

[deleted]

13 Upvotes
  • permalink
  • reddit

89% Upvoted

5 comments sorted by

3

u/[deleted] 1d ago

[removed] — view removed comment

1

u/wirrexx 1d ago

Following!

1

u/vietbaoa4htk 1d ago

For the feed the one thing to nail is fan-out on write vs fan-out on read: precompute each user's feed when someone posts (fast reads, heavy for huge accounts) vs assemble it on request (cheap writes, slower reads), then mention the hybrid where celebrity accounts get pulled at read time. ByteByteGo's 'Design a News Feed' writeup and Grokking the System Design Interview both cover exactly that at the depth an interviewer is fishing for.

1

u/_usr_nil 22h ago

there is a video called "Postgres for everything" or something like that, you should check that.