From the outside, social features seem like something straightforward: follow a user, like a post, see a feed, but when you attempt to implement them at any real scale you find that every single one is something you've got to be aware of, a pattern, a well-documented query pattern with all its fa...
Source: [Dev.to](https://dev.to/meroline_lizlent/sql-patterns-hidden-inside-social-networks-pc5)