New posts in Social Networking

How do sites like LinkedIn efficiently display 1st/2nd/3rd-level relationship next to each person's name?

How to implement the activity stream in a social network

Database design: Best table structure for capturing the User/Friend relationship?