2 ms·
"Let's move on to the next question... how would you design a sort-by-date feature for a video streaming service? We have 15 minutes before the next interviewe
by khazhoux 4y ago
"Let's move on to the next question... how would you design a sort-by-date feature for a video streaming service? We have 15 minutes before the next interviewer comes in, so get started."
- jagged-chisel 4y agoApparently the correct answer is “I wouldn’t, because someone in Retention has a ‘better idea’ for how to keep eyes on the site.” But just for giggles, I’d have placed all video metadata into a relational database (the interviewer grimaces), and use SELECT * FROM metadata /* a WHERE clause here to match the user’s actual search */ ORDER BY creation_date; And I’m not being offered the job because I didn’t use a NoSQL store and didn’t consider writing a DSL to make queries and no mention of inverted binary trees to sort the data by “relevance” according to Retention.