Ask HN: How would you design a Social Network DB schema?

1 points by allfou 9 years ago

Let's say you have to handle: Users, Videos, Comments (on each videos), Likes (on each videos) then Connections between Users (Social Graph).

What is the new-fresh-2016-optimized way to design such a database?

Thanks!

unimpressive 9 years ago |

https://en.wikipedia.org/wiki/Boyce_Codd_Normal_Form

Maybe I'm just not familiar enough with the subject, but I thought the entire point of database schemas was that they're theoretically rigorous and help you avoid exactly the kind of faddism you're asking for.

dman 9 years ago |

How would you do it?

angersock 9 years ago |

Look, we won't help you with your homework--why would we help you with your technical due diligence?

allfou 9 years ago | |

By "we" you mean "I", right?