Це відео не доступне.
Перепрошуємо.

Google SWE teaches systems design | EP29: Geospatial Indexes

Поділитися
Вставка
  • Опубліковано 2 тра 2022
  • Let's find some Milfs!
    Recommended Reading/Viewing:
    • System Design Intervie...
    gis.stackexcha...
    eng.uber.com/h3/

КОМЕНТАРІ • 36

  • @tester14325
    @tester14325 2 роки тому +19

    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.

    • @jordanhasnolife5163
      @jordanhasnolife5163  2 роки тому +6

      Thanks Eric, means a lot!! I'm definitely learning a ton and having fun in the progress, hope you're getting something out of it as well!

    • @2tce
      @2tce 2 роки тому +2

      No doubt. This is by far the best fast, yet in-depth distributed system design series I've ever come across. It will BLOW!!!
      I wish there was a way to invest $$$ in this channel :)

    • @easywoo
      @easywoo Рік тому +4

      Can't agree more! This is some unbelievable learning and sharing! Very inspiring! Jordan, is that the reason why you "have no life" cuz you spent all your time on this and working out? haha

    • @jordanhasnolife5163
      @jordanhasnolife5163  10 місяців тому +1

      yep

  • @rodrigoalvesvieira
    @rodrigoalvesvieira 2 роки тому +5

    Best material on UA-cam on the distributed systems. Thanks!

  • @oniyaolaiya9826
    @oniyaolaiya9826 2 місяці тому +1

    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
    @trumpetharp 2 роки тому +3

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

    • @jordanhasnolife5163
      @jordanhasnolife5163  2 роки тому +2

      Thanks for watching! The positive feedback keeps me motivated haha

  • @danamyrocket
    @danamyrocket 6 місяців тому +1

    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
    @Snehilw 2 роки тому +2

    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!

    • @jordanhasnolife5163
      @jordanhasnolife5163  2 роки тому +2

      Yeah, i may do this. I don't love the idea of making redundant videos, as there are plenty of them on LeetCode, but ultimately I may just start with Leetcode and then get into more complicated topics. I've wanted to get into competitive programming anyways, so perhaps making videos on it would help me learn.

  • @zzzfortezzz
    @zzzfortezzz 4 місяці тому +1

    Thank you

  • @kirthe1116
    @kirthe1116 Рік тому +2

    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
    @KratosProton Рік тому +1

    Very nicely explained, great explaination!

  • @harshchiki7796
    @harshchiki7796 2 місяці тому +1

    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)

    • @jordanhasnolife5163
      @jordanhasnolife5163  2 місяці тому +1

      You're right that there's not a direct ordering, but for a given geohash I do know all of the 8 hashes of the surrounding boxes so I can just check all of those with a Pythagorean equation to check things are in the correct distance from my focal point

  • @riteshsingh1245
    @riteshsingh1245 2 роки тому +1

    Great stuff explained in very easy manner

  • @whirr9755
    @whirr9755 2 роки тому +3

    can you make a video on recommendation systems?

    • @jordanhasnolife5163
      @jordanhasnolife5163  2 роки тому +2

      Well yes and no haha - from a systems design perspective I'll probably do it as a practice question eventually. From a machine learning perspective, probably not just because that's a whole different area than what I'm covering.

  • @MohitSehgal-cy8bb
    @MohitSehgal-cy8bb 4 місяці тому +1

    I am lucky to get this video.

  • @ramjishkl
    @ramjishkl 2 роки тому +2

    awesome content ...great work

  • @raj_kundalia
    @raj_kundalia 11 місяців тому +1

    thank you!

  • @mnchester
    @mnchester 2 роки тому +1

    great video!!

  • @ianokay
    @ianokay 10 місяців тому +1

    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?

    • @jordanhasnolife5163
      @jordanhasnolife5163  10 місяців тому

      It's linear in the worst case when all points are within the latitude that you care about but spread out all over the place with longitude

  • @2tce
    @2tce 2 роки тому +1

    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.

  • @jameslau5485
    @jameslau5485 22 дні тому +1

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

  • @2tce
    @2tce 2 роки тому +1

    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 :)

    • @jordanhasnolife5163
      @jordanhasnolife5163  2 роки тому

      Yeah I'd have to say that if you only need to index a certain area then only store hashes for that area.