Відео

Hi, Evan! Have a question: When explaining the B-Tree-based indexes, you said, "We pull page 3, which contains all the users with age 55." But what if there are more than one such page? Let's assume the primary key, i.e., the clustered index, is not on age, so it could happen that users with age 52 might reside in different pages.

Need more of these.

Love your content. Can you make videos around concurrency, race conditions in distributed systems. And how can we design database models with better FK references in complex systems. Thanks!

Great content mate, made me buy premium. hope it will help with my FAANG intreviews

I don't normally leave comments, but I just wanted to say these video are incredible! I'm a junior/mid level engineer, and I have been using your system design videos and guides to help prep for sys design interviews and I feel very confident about them now :)

Youre definitely gonna hit 100k subscribers soon. I’ve been studying for fang interviews and this content is gold.

this is really helpful, easy to understand about 4 type of indexes

7:20 What if I want to get neighbours of the area that's located in the boundary (e.g. "310") ? Their prefix are not same in this case.

Evan- Your way of structuring things makes things easier a lot.. Continue doing more! Between, when are you stepping into AI coaching?

This was very helpful. From thought process to finally what we came up with, everything was top notch. Thanks

Clicked for content, Stayed for Evan's handsomeness.

Thanks hello interview and Evan!!

The length is perfect! It's fine to go over, you deliver lots of value love all the depth conversations! Thank you!

absolute best content. keep up with great work :)

This was very helpful. Thank you.

12:43 The slide shows DynamoDB still 😂

I got an offer at Meta thanks to your videos Evan, keep up the great work!

Awesome 👏🏽

Changing the visibility timeout in SQS only affects how long the message remains hidden after a failed processing attempt, but once it becomes visible again, any worker polling the queue can immediately pick it up. The worker failure (in this async processing design pattern) can have 2 broad categories: 1. long running task (genuinely big workload that requires longer timeout) 2. transient or external dependency failures (5XX). Increasing visibility timeout helps with case 1. For case 2, a dedicated retry queue with delaySeconds configured is better.

Where do I learn more about concepts like these

Hi Evan! Had a video idea. Maybe you could have an actual “mock” interview at different levels to showcase what an L4 vs L5 vs L6 kind of interview looks like. You do mention “an L4 or more junior would be happy with saying <this> bit for staff you’d need more. But a full interview at that level would be interesting. I have been studying a lot and I would like to see if I’m getting closer to L5 tier responses or still at the L4 level. Thank you!

Amazing video, subbed up.

thank you!

might be a stupid question, but for the weirdos who asks us to do the back of the envelope calculations, can anyone tell me what exactly the ones to do ? Would like to know beforehand just to not waste too much on it if forced to do them.

Awesome video (as always), thank you!

Had a system design interview last week. My first one. Was confident enough to not go bad because i watched your videos and used your format. Need to practice more, learn deeper tech, still a long way to go to be able to perform well for any prompt/ followup on choices. Waiting for a reply! Lets see. Really loving this concept of working with system design ❤ Live examples of scalable systems as well as deep dives into specific technologies that are used in these videos. Would love videos regarding Kafka/Queues, CDC, Redis(distributed loc)? if possible. Nonetheless, thank you for creating such great content ❤

actually one of the great topics, need more of these

you forgot to say "thanks for watching, If you enjoyed this content, subscribe to the channel as it helps (...) & make sure to leave a comment below what technique you learned today.thanks for watching and see you next time, "

Thanks Stefan! Strong disagree with Austen at the end with respect to the “tell me about a day in the life of an engineer” question. This has varied wildly at companies I’ve worked at and I think a lot can be gleaned from asking it. It’s a little disappointing he seemed to be looking down upon candidates that ask it.

Great video. I actually had to add a Postgres inverted index for a search feature I made due to performance issues and learned about it that way. Cool to see that it's what you would recommend for full text search.

ur content is so different than others, i can tell u are brilliant.

Thank you, Evan! I truly appreciate how you simplify complex concepts into easily understandable insights. Absolutely hooked on your System Design videos-looking forward to many more!

Really good 👍

Where can I find the excalidraw you used for this?

Great explanation and design! Would like to know what are the pitfalls of an alternative design using Kafka with Kafka Streams. Thanks!

hi guys i daily follow You'r videos they are excellent can u make a video on Optimization of Sql,Spark code or how to approach for optimizing question in interview

A happy Sunday morning starts with a fresh new Hello Interview video ❤❤❤

Fun fact in Geohash initially, the world is divided into 32 large squares (4x8) - 4 high 8 wide as roughly the world is twice as wide as it is high!

but some DB's aren't page-oriented, right?

Amazing Video! Thanks for quick high level overview !

wanna see more on this topic

Does the last slide say DynamoDB Conclusion?

So much quality content packed in such short time. Very helpful to revise. 🙏🙇‍♂️❤️

Thank you evan!

waited so long for this video

thanks @hellointerview, thanks @Evan!

Nice video. A quick observation on 17:15 minute - would you think the PATCH API could be cleaner and more "Restful" as: PATCH ../rides/{id}/driver/accept (ride id in the path vs. body) ? And so for reject: PATCH ../rides/{id}/driver/reject. And the following question is if POST won't fit better in this case, as it's more than just a resource update (to be RESTful, the /accept should go into the PATCH request's body).

Should you also not write a navigation service that helps drivers navigate to the next location (maybe a redirection service that redirects them to the 3p mapping service)?

Hi Even, thank you very much for your great video. But there is on point I don’t fully get it, the way you handle hot shards problem by adding number randomly at the end of AdID. What would happen if we have few popular Advertisements? In that case, we might need an executor for all shards. Is my assumption right? Really hope that you can help me to clear that. Or anyone here know the answer, could you please help me?

How do coordinating nodes know which shards contain what documents? From your description, it seems that each shard has it's own local index and there is no global index. So do coordinating nodes perform a scatter/gather operation?