Google SWE teaches systems design | EP29: Geospatial Indexes

Let's find some Milfs!

Recommended Reading/Viewing:

[tester]

great stuff. Ignore the views - over time feel like this channel will blow up. thanks for the dedication. wish i had the dedication to do something like this not for other people but just for my own knowledge - cant imagine what you have learned from doing all these videos. great job.

[rodrigoalvesvieira]

Best material on YouTube on the distributed systems. Thanks!

[oniyaolaiya]

I wish you would do more videos explaining things like this. I'm a Techpreneur and I'm trying to create a ride-sharing business and there are lots of details that this video has put in context for me. Thank you very much Jordan.

[trumpetharp]

The content and style is really good. Thanks for the effort and keep up the good work!

[danamyrocket]

One of the most interesting aspects of working with the mapping groups at some of those companies was their pathological stubborn refusal to consider using off the shelf/best-in-class solutions, like Postgres with PostGIS extensions, along with using GDAL/OGR as their geospatial operations library.

It was like watching someone pour gasoline on a huge pile of cash and lighting it on fire. Every month.

Some even refused to geo-align their collected data with a widely used datum, EPSG:4326(WGS-84 w/recent update) so they couldn’t import data from other sources OR generate revenue by selling geodata to potential customers. What a MCF.

[Snehilw]

Super dope content! You should create content on Leetcode patterns and cracking coding interviews after System Design, and then this channel would most likely become the premium one stop shop for coders world over for interview prep!

[kirthe]

Great Content! It was super helpful. One small suggestions would be In your title when viewing on playlist, we are not able to half of the title. if you can start with topic and then mention google SWE. I think it will be helpful. Thanks

[KratosProton]

Very nicely explained, great explaination!

[riteshsingh]

Great stuff explained in very easy manner

[harshchiki]

Did not follow the range query across geo hashes, in the slide where we were calculating the nearest points (slide having the diag of boxes)? Geo hashes don't have a mutual ordering - or do they? (if you don't mind, can you share a bit on that)

[whirr]

can you make a video on recommendation systems?

[jameslau]

want to thumb up but really dont wanna break that 256 likes..

[ianokay]

If you have a multi column index why would it be a full table scan to ensure that the longitude is within the correct bounds also just as the latitude must be?

[tce]

How can we cache hot searches? I think we can have another Redis instance within same node that can cache hot searches (Geohashes) using LRU.

[tce]

So if my business is only serving a particular region, say Nigeria or Africa, then it wouldn't make sense storing ALL the geohashes of all coordinates in the globe right? It would be better only persist a subset to Redis. Counter to that, it seems this that if we have a distributed Redis cache totaling 1 TB for instance, it would not hurt to save everything. Penny wise, Pound foolish :)