Google Interview Question | System Design: Photo Sharing Service (5+ Approaches)

[@ManavMittal-v3d]

Video starts at 12:46

[@rohit-ld6fc]

need a detail explaination of db trigger, there is no such db trigger to kafka or s3. you need a worker code there

[@SDFC]

NOTES & CORRECTIONS: - excalidraw file: - final link from the live session: excalidraw.com/#json=s9GiA-SrWbn5w4KCIhJgF,yCfG89cMzOrSAf3SsjCB5Q - I moved stuff around and added labels for the screenshots: excalidraw.com/#json=p3i7r2gQjY27rmsl2Yt38,1Qc1za7h0KV3cdIyU5eg8g - screenshots of the excalidraw file: imgur.com/a/YkARId5 - text file: pastebin.com/Df6drEVK

[@GD-tw8mz]

Hey, thanks for your video! For the album db, album uuid is used as the partition key. Then how to deal with hot partitions since some album could have celebrity issues.

[@90abyss]

whats the partition key in the metadata table? username or pic_id?

[@rakshiths.n9680]

Plz give the materials

[@SDFC]

They’ve been added to the video description. I tried adding them as a pinned comment as well, but youtube seems to be deleting or hiding that comment-it might be treating the links as spam

[@laurentarn]

You spent too much time on the question, it's kind of long to watch the replay. Could you stick to 45min like a real sys design interview?