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

Posted by allfou on Friday November 25, 2016 @04:26PM
from the ask-hn dept.

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!

( 4 comments | on HN )

Re:Ask HN: How would you design a Social Network DB schema? by unimpressive on Friday November 25, 2016 @04:38PM (#13040042)

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.

[ Parent | on HN ]

Re:Ask HN: How would you design a Social Network DB schema? by dman on Friday November 25, 2016 @04:39PM (#13040055)

How would you do it?

[ Parent | on HN ]

Re:Ask HN: How would you design a Social Network DB schema? by angersock on Friday November 25, 2016 @04:39PM (#13040050)

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

[ Parent | on HN ]

Re:Ask HN: How would you design a Social Network DB schema? by allfou on Friday November 25, 2016 @04:46PM (#13040102)

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

[ Parent | on HN ]