Full-stack projects
🌐 Project: social network
Model a real social network: users who follow each other (a graph), a feed that gathers the posts of who you follow, likes, and the famous N+1 problem when loading authors.
What you'll learn
- Model the social graph of followers with an N:M relationship of the users table with itself
- Build the feed in SQL and in JavaScript by gathering the posts of who you follow
- Implement the like toggle and the Post component in React
- Diagnose and solve the N+1 problem by loading the authors in a single shot
Lessons
The plan: users, followers and the social graphWhy followers form a graph (N:M relationship of a table with itself). The feed and the N+1 problemHow the feed is assembled and why loading the authors one by one is a performance disaster.Practice this module in the app
DevPath is a hands-on course: you read the theory here; in the app you put it into practice with exercises that really run, offline.
Start free in the app →