Bloody hell, the idea about geohash4, geohash5, geohash6 is so simple, but at the same time is so genius (by the time of writing the message I've already watched a few videos about geohashing and proximity servers). I had plans with my girlfriend to do some Netflix & Chill, but I guess I would rather continue watching your other videos on Systems Design. Superb stuff!
@irtizahafiz
Жыл бұрын
Haha! You clearly got your priorities sorted out. Glad they are helpful to you.
@imiebaka
Жыл бұрын
I like this. Sometimes it's good to always see how to optimize solution. I was jumping for joy that I could use the LIKE and boom, the multiple column nailed it.
@fierce2321
Жыл бұрын
One of the best system design video I have ever seen, period. Let alone being best SD video on proximity service. Awesome explanation. Mind=blown
@irtizahafiz
Жыл бұрын
Glad you liked it!
@arpit35007
Жыл бұрын
It's a great video man. One thing that should be added is, we just don't lookup for one geohash, we also calculate 8 neighbours and then do a lookup.
@tanaygupta632
4 ай бұрын
@arpit35007 what do you mean by that ? and how do we calculate 8 neighbours ? and what exactly are these neighbours ? are these 8 nearest quadrants which have multiple businesses in it ?
@oluwie
2 ай бұрын
@@tanaygupta632 you'd want to calculate neighbors for the bounding problem. imagine a location is at the edge of a quadrant. you'd want locations at the next quadrant as well since those locations could be closer to the user than any other locations in the same quadrant, so you'd want to get all locations in adjacent quadrants and then sort on distance to the query. there are libraries you can use to get neighboring hashes for any given hash
@석상주
2 жыл бұрын
This is awesome. Best youtube channel regarding system design. Keep it up!
@irtizahafiz
2 жыл бұрын
That means so much! Really appreciate it. Hope you continue getting value out of the content.
@schan263
8 ай бұрын
Thanks for the great video. I think it would be even better if the video mentioned the scenario where the user could be near the edge of the grid and should also return the neighbour grids. Or we should always return the neighbouring grids if it's too much work to figure out if the user is near the edge of the grid or not.
@irtizahafiz
6 ай бұрын
Huh, I thought I mentioned that. Maybe not then. Thank you for pointing it out.
@Khushboo1811
Жыл бұрын
Your content is amazing and so helpful.. Thanks for all the efforts that you have put it in , and making our lives easy :)
@irtizahafiz
10 ай бұрын
Thank you for the kind words. Hope you enjoy the upcoming videos as well.
@poonam-kamboj
11 ай бұрын
nicely explained. thanks!!
@irtizahafiz
11 ай бұрын
Thank you! I will start posting again soon, so please let me know what type of content interests you the most.
@arunsatyarth9097
2 жыл бұрын
I think you should have discussed the edge cases of using geohash
@irtizahafiz
2 жыл бұрын
I believe I have another video on Geohash. That's why didn't go into depth here.
@soumyajitganguly2593
Жыл бұрын
@@irtizahafiz you didnt discuss edge cases there either :(
@raveendrajonna4756
2 жыл бұрын
What is the Tool/ IDE you are using , Its very nice, i also want to start using.
@irtizahafiz
2 жыл бұрын
Hi! I am using Obsidian for the actual notes, and Miro for the diagrams. obsidian.md/ miro.com/ Both are free tools that you can use : )
@TheZhengdu
Жыл бұрын
The note shared seems to editable by anyone, it may get lost if someone click the wrong button.
@andr101
3 ай бұрын
If the user is located near the boundary of a big cell 9a, the method proposed in the video won't get all those locations which are in proximity of the user but belonging to an adjacent big cell (9b, for example). How would you work around this issue?
@chrishabgood8900
2 ай бұрын
Around 22 or so I would name columns like geohash_1, _5, _10, so you could dynamically interpolate when the query comes in.
@ihsannuruliman4005
8 ай бұрын
Since these are stored as prefixes, can we use trie data structure here? If so, why don't we use it? We can use graph database and store every prefix as node, and the next prefix (the deeper levels) as children. But looking at it I don't see any trie-based geohashing implemented in DBMS, tho.
@irtizahafiz
8 ай бұрын
I am not really familiar with trie-based geohashing DBs either.
@calgjg
5 ай бұрын
This caching design assumes all business categories are homogenous. How might this support say searching for just coffee shops around a location instead of all businesses at location, that might include laundromat, etc.
@irtizahafiz
5 ай бұрын
You can cache results sliced by business category, though you will be using up more space.
@Ganeshkanagavel
11 ай бұрын
Very High Clarity in the thoughts and presentation, Would be very helpful if we extend for 5 more minutes covering the Quadtree or Google S2 based approach as well
@VaibhavKarbhajan
8 ай бұрын
Very informative and explained practical usage of handling maps via geohash. Thank you for this video.
@Sdirimohamedsalah
Жыл бұрын
Any idea to locate a business in movement like taxi or distributors .. ?
@shis10
4 ай бұрын
Amazingly explained
@조바이든-r6r
2 жыл бұрын
ive been waITING FOR YOU!
@limitlesspotential3879
Жыл бұрын
@irtizahafiz Thank you for such a crisp and clear video. It was very helpful. I have a question about how the data is being stored in cache. We are storing list of business ids. so when a new business gets added wont it be difficult to insert that new id into the existing list? Also you showed the post processor to add into the Cache. What if the processor dies after consuming the message? How do we avoid duplicates in the cache then? I would really appreciate if you can answer these questions
@irtizahafiz
10 ай бұрын
1. Redis and some other caching mechanism gives you an easy way to append to a list. 2. You could use a set. For example, Redis gives you a set data structure to use in-memory.
@Sdirimohamedsalah
Жыл бұрын
Special thanks !
@neurocat6453
Жыл бұрын
I usually watch your videos on 1.5 speed and background music sounds like some crazy mobile space arcade :D
@irtizahafiz
10 ай бұрын
LOL yeah I think I stopped adding music after getting multiple feedback.
@harshitchauhan7363
Жыл бұрын
Awesome!!
@philtoa334
2 жыл бұрын
Very good.
@flashliqu
2 жыл бұрын
Raise hand, what is the difference between Geohash and Quadtree, could you record a video to tutor?
@irtizahafiz
2 жыл бұрын
Hi! That's a really good question. I did go down the rabbit hole of understanding how they differ from each other. I can make a video about it in the future : )
@abhirupacharya010
Жыл бұрын
Amazing explanation!! Please keep up the sensational job
@irtizahafiz
10 ай бұрын
Thank you for watching!
@sergiim5601
2 жыл бұрын
Amazing content, very clearly explained all nuances and approaches !
@irtizahafiz
2 жыл бұрын
Glad you think so!
@pratiksingh9953
Жыл бұрын
thanks, very informative.. keep up the good work 👍
@irtizahafiz
Жыл бұрын
Thanks for watching!
@6365bharath
2 жыл бұрын
Loved it. Such an underrated channel.
@irtizahafiz
2 жыл бұрын
Much appreciated!
@pspskat
2 жыл бұрын
Very clearly explained. The best system design video i have seen.
@irtizahafiz
2 жыл бұрын
Really happy to hear that : ) Let me know if you have any feedback.
@abhishektayal8313
2 жыл бұрын
👍👍
@mahanteshambali
Жыл бұрын
Great stuff. Thank you for putting your efforts on this topic.
@irtizahafiz
10 ай бұрын
Glad you found it helpful!
@silapukanan952
2 жыл бұрын
Does MySQL come with CDC feature automatically? If not, how is CDC implemented between mySQL and kafka?
@mohsanabbas6835
2 жыл бұрын
I think there is connector for that Debezium
@irtizahafiz
2 жыл бұрын
You need a connector. MySQL will write about all the changes happening in a bin log I believe. You need a connector to read/format from this log file and then write formatted messages to Kafka.
@JemilOyebisiDeveloper
2 жыл бұрын
Great content and well articulated, keep the great job going man!
@irtizahafiz
2 жыл бұрын
Much appreciated! Let me know what else you are interested in.
@digitalmastery3736
2 жыл бұрын
amazing , kudos to you
@irtizahafiz
2 жыл бұрын
Thanks a lot!
@ramgilaka6146
Жыл бұрын
This is Gold!... where you have been all these years mate!. If I make a app with this knowledge ..I might share the royalty as well... ... Thank you
@irtizahafiz
10 ай бұрын
Haha! So glad to hear that. Let me know if you ever end up making an app. Would love to see how you apply these concepts.
Пікірлер: 64