We are working on a clone of Facebook. We want to add a numeric count to every post showing how many friends the post" author has at the time of viewing the post, like this: Marie McWilliams (105 friends) I had a great day today, feeling good! Our database has two tables: USER 'user_id' (primary key) 'name' 'created_date' USER_RELATIONSHIP 'friendship_id' (primary key, unique to each relationship) 'user1_id' (indexed) 'user2_id' (indexed) 'start_date' Focusing on the database, how would you implement the friend-count feature? Note we will soon be more popular than Facebook, so the solution needs to scale.
