Before we proceed down the path of denormalization, let's first try an approach that requires adding no new tables to our schema. Our goal is to display to a user all the status updates of all the users they follow, the most recent first. So, the simplest approach would be to simply look up the followed users and then retrieve their status updates.
If you've been following along with the code examples so far, you should currently have a single follow relationship in the database, such as alice follows carol. To make things more interesting, let's also have alice follow dave:
INSERT INTO "user_outbound_follows"
("follower_username", "followed_username")
VALUES ('alice', 'dave');
INSERT INTO "user_inbound_follows"
("followed_username", "follower_username")
VALUES ('dave', 'alice...
