Corrections: In the geohash length to grid size mapping table at 15:30 and 20:01, the correct values for 7, 8, 9 and 10 are: 7 152.9m × 152.4m 8 38.2m × 19m 9 4.8m × 4.8m 10 1.2m × 59.5cm

Hey KZfaq algorithm, if you’re reading this, I just want to say, this is the type of video you should be recommending to software people. K thanks

Best design video ever. I am so happy that Alex decided to make videos.

this video is a FLOW. Could not stop watching... Beautiful animation and narration. Perfect

So much effort spent in how to make this video so informative, well structured, precisely explained and amazingly illustrated. Thank you for sharing this with us!

We need more full system design videos like this one from you!

Holy crap... finally a guy that actually knows what he's talking about. I've been doing this for 20 + years and this is how it's done. Kids you don't need to make it overly complex, just build it so it can scale not at scale.

I have been following a number of channels related to system design in last few months. While many of them are brilliant, Sahn has a very unique and effective way of communicating complex technical topics. Thanks Sahn and team for this content. Hope to see more of these.

This is by far the BEST VIDEO on questions like "Design Yelp". Pure Gold !! Thanks, Alex, and ByteByteGo team for your outstanding work.

I just started reading volume 2 of System Design Interview and I'm really enjoying the content so far. Even more so when I realized you created videos to further solidify the readings! Keep them coming!

Notes: - The SQL query at 20:27 would not work for the same reasons you mentioned previously in the video (prime meridian + equator). - You assume that the long/lat is the centre of the business/place, if users are able to add their own businesses this will probably not be the case - Businesses/places can span multiple grids (think of shopping malls) - Businesses/places can be bigger than a grid (think of airports) - At the very end you say it would "use the long/lat to rank the businesses and return to the client" (sorting), you also need to check if the business is still within the radius the user specified (filter); just because the business is in the same grid/neighbouring grids doesn't mean its within the radius they asked for. The first thought might be to make the geohash a list (of all the grids that it covers), but how do you calculate that? You would need a polygon (a long/lats for each vertex) that covers the (rough?) area of the business/place, then you get onto the trouble of validating that :)

In early 2000s we designed such a system for a popular real estate site very similar. We thought we had nailed the algorithm, but started getting complaints from agents and consumers. It turns out in that domain “distance” is almost always driving distance which is an entirely different problem and was much more complex in the days before quick road route planning 😀

Thank you so much for starting to make these videos. Your step by step approach is so clear and crisp. Best System Design material ever!!!

Hey, Alex. I learn x100 times more from this video than from my past year in IT. Totally awesome content!

By far the best system design channel ever. Crisp presentation and fluid animations to easily showcase complex topics in a simple manner.

Wow, I'm an enterprise software engineer and from my work experience and knowledge, this is one of the best channel that digs into the ways of working and architecturing an enterprise software. Kudos 👏

This video should be taught at universities and bootcamps. Not only for the interesting topic but also to learn how to think about this kind of problem and system design in general. Thank you!

This is such an underrated channel - very good visuals, concise speech pattern, and extremely well thought out approach to each topic

This is an awesome video. I liked how you were able to break down complex concepts so that even beginners could understood them at a high level. Was able to learn a lot under half an hour about the complete picture of system design

Fantastic system design content. Really appreciate the clear explanation of logic used to estimate the system requirements and then determine the approach to the design.

2 minutes in the video and liked it already 👍. What an amazing way of explaining stuff, simple yet effective slides. Thanks man appreciate your efforts.

This was super fun to watch and got me interested again in algorithms and systems in general. I decided to go ahead and buy the two books straight ahead. So having a youtube channel definitely helps getting the word out :))

If we can have some sort of video course also like the book you published, I would buy the course right away. The content and the explanation you deliver is really simple to understand and that's the beauty of a good Teacher. "Explain me like I am 5th grade" This really goes for you!

This is hands down the best design video I’ve ever seen

Please continue making videos. The speaker did an amazing job, clear with a nice tone. The visual presentation is also nicely executed. 10/10, subscribed.

Please continue to make such wonderful videos. It’s pure gold, glad I discovered the channel.Thank you

he explains like a teacher you would find in a school that everyone loves

The design elements are at another level! Great work! Keep it up!

Absolutely love how succinct and on point the explanation is.

I've watched like most of the SD videos from YT, i could tell you guys this one is the best. Thanks Alex

You sir are a natural for teaching, please dont stop, you're doing world a favor! Cheers !

I bought Vol 2 but I find video format slightly easier to digest. I really appreciate you making these videos.

I am currently going through the System Design Course offered by Design Gurus on Educative which covers similar concepts but in a text based format. I have heard a lot about ByteByteGo's courses and books as well and I'm glad that I looked up this video. Thanks Alex and the team!

wow - what a wonderful video. So well thought out - clearly lays down the ideas using very easy to understand visuals.Thank you so much Alex.

Your approach is fascinating. It kept me watching the whole video and I find this very rare. Thank you.

Another eye-opening video. Thank you very much for these high quality, insightful videos. Great work!!👏

This has to be the highest quality system design explainer video on KZfaq. * take a bow *

As humble as he is, his videos are super awesome too. Go alex..!!

Great explanation with concise and well mapped out diagrams. Amazing!

As usual amazing video with great details. Thank you Alex. Wish to see more videos of length 20+ mins.

A clear and in depth explanation of the proximity service design. Specifically I liked the detail ways to index the geospatial databse.

You are the best person to explain that content. Thanks to share it with us!

I got this question on my Meta on-site interview. Absolutely bombed it.

This is one of the best technology videos I've ever watched! You explained everything very well and with great, informative graphics. Only small suggestion - maybe use a mono spaced font for the queries etc. to improve readability. Thanks for this!

I had exactly this problem on my system design interview @ faang, failed it miserably)) Excellent quality of material here, will help a lot in future!

Very clearly demonstrated and described. Love it! Thanks.

Would definitely love to get more full systems design interview videos like this from you. Great video!

Amazing! Beautiful! Super high quality content! So eager for the upcoming videos!

This one video introduced me to so many concepts. Thank you Alex.

I have tried different videos but this one definitely stands out for understanding location based system design.

This is the best system design video I've seen so far. Great job mister

Gr8 design video. Thanks Alex for such high quality, clear concise explanation.

This channel gonna blowup. The graphic designs are the game changer

Loved it, well made and highly educational. Looking forward for more of those.

Dude, your content is gold! I've been coding almost 20 years and prepared for interviews countless times. This has been one of the best content so far!

I have your System Design Interview Volume I book... Never knew you were the author :) I learned CAP theorem, eventual consistency, and many others from it... I wasn't aware that there is volume 2.. will be adding it to my cart... Great explanation once again!

This content is unbelievable. Will be checking out your books and newsletters!

i hope u make 10 videos everyday so i can learn forever about system design. Thanks so much

Amazing, the style of the video makes it very easy to grasp the concept!

This video is GOLD ! Thanks a lot, looking forward for more content !

I am truly thankful for these videos, please keep making more !

Mindblowing content and way of presenting it! Thank you so much! Keep it up!

Beautiful poetry just opens up my eye. Overwhelmingly grateful. 🙏 and ❤from Chennai 🇮🇳

The best System Design video so far! Thanks and Keep it going!

you opened my mind about the system design. unbelievable

15:37 for 7-10, units would be in metre not km

Great video where everything was clearly explained. Thank you!

One of the best technical video i have ever watched

I really like this video, the presenter is very friendly and calm, please extends this, I would like to learn more. You got +1 sub from Tanzania 🇹🇿 Greetings from Tanzania 🇹🇿

Absolutely love this video! 15 year old me craved this information but got it after 8 years

Super Awesome !! Great work Alex !! Thank you so much for sharing the great design video.

This is by far the greatest video, thanks a lot for putting this together ❤

This is amazing, what a gem of a youtube channel !

Today I learned something new! Thanks Alex!

Another great video with clear explanation and informative graphs for software engineers

This video is so good, i need to watch it a few more times, there is a lot of valuable information here

Awesome! The best system design video. Keep doing your great work because it helps people a lot.

I learned so much in this video. Thank you.

Excellent video! I guess there must be a lot of efforts invested. Keep up! Thank you!!!

Thanks so much for this Sahn! I really appreciate the greater depth of this one :)

I'm really lucky to see this video released. It's been about a year since I work in the area of location based service. There is not much of related information that is up to date. Thanks a lot for this video! Keep on!

Thank you for making this video. This is gold.

Great video, a lot of good information in just 24 minutes

Bought your book on system design. Great experience, thanks!

Amazing video, thank you for sharing knowledge in such well presented way.

Thank you for making it simple.

like very much this kind of videos with an example of a system design! thanks

This is awesome material. Thank you so much!!!

Best design videos I have ever. Keep the good work.

Thanks a lot. Very clear and helpful!!

Thank you so much. Its simply fantastic 🙌🏻

This is gold! Toss in a Geosptial DB on your interview and it’s sure to impress them

This is a gold mine, thank you!!!

This Video Is Great. I Learn a Lot Thanks for making this video.

this is really amazing system, thank you so much

Nice video!! A lot of good information in just 24 mins, very nice... Thank you.

Fantastic explanation. Great job. Waiting to see more system design videos from you. Good luck

Excellent content. I liked your structured way of thinking

This was a great video with good emphasis on design details.

Thanks a lot for creating these videos. 🙏