April 2017
Beginner to intermediate
360 pages
9h 35m
English
Now let's say carol and dave each creates a new status update. As earlier, we will not attempt to backfill home_status_updates with status updates that were written prior to its creation; we'll just propagate new status updates to the home_status_updates table:
SELECT "followed_username" FROM "user_inbound_follows" WHERE "followed_username" = 'carol'; INSERT INTO "user_status_updates" ("username", "id", "body") VALUES ('carol', cacc7de0-2af9-11e4-8069-5f98e903bf02, 'carol update 4' ); INSERT INTO "home_status_updates" ("timeline_username", "status_update_id", "status_update_username", "body") VALUES ( 'alice', cacc7de0-2af9-11e4-8069-5f98e903bf02, 'carol', 'carol update 4' ); SELECT "followed_username" ...Read now
Unlock full access