Events Add an event Speakers Talks Collections
 
Duration 02:37
16+
Play
Video

PGConf India 2020 - Lightning Talk - Routing in Postgres - Sangarshanan - Grofers

Sangarshanan Veera
Engineer at Grofers
  • Video
  • Table of contents
  • Video
PGConf India, 2020
February 26, 2020, Bengaluru, India
PGConf India, 2020
Request Q&A
PGConf India, 2020
From the conference
PGConf India, 2020
Request Q&A
Video
PGConf India 2020 - Lightning Talk - Routing in Postgres - Sangarshanan - Grofers
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Add to favorites
25
I like 0
I dislike 0
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
  • Description
  • Transcript
  • Discussion

I thought today was rotting in postgres. Most about postgres is the emergency of Extinction that is that it has, and it's all community. So my favorite, my favorite thing before stress, is that with your special extensions and my favorite ones are opposed is our first just depending on how you're feeling that day. And also busy outing has also has extensions like a Porsche is topology at stuff like that. Like, it depends on if they can be used for. And also. He has another job site called always seem to be getting

there. You can convert your road network data into a football player compatible graph. I don't like nerds images. So hard. Now, how do you do routing in postgres? The first step to do is to download are thrown at odetah from OSN, openstreetmap to download your data. I don't know about that because I love my ramp and then I ran always, I'm too busy writing. I choose the 5. If they want to run it on, I give it the configurations to congregation Shir, is only to take the road Network, which is not compatible Acorn, Leaf, New Roads, where you can drive a car, which is actually very

Less in Bangalore and you mentioned your name, you give it to username and it loads, I can create the tables in your database and rabies create are ways and ways versus so which includes a bunch of nerds and edges with and you can just use it without Don't know how to create a note that I just looked at a bunch of nerds in ages. And you can also give Ethan every note, and it also has bait and attributed with it. We can also say, where the road is 1V, whether there is traffic on the road, whether the vehicle rolled his car compatible by

compatible. We have, I said now, you know how to rotate? Now, we have to let Long's this to like songs can live anywhere. Now, we just created a database and find out the nearest note to do that long. Now, we have to do notes and we have all the ages and we can use any kind of pathfinding algorithm to find out the road network but it's a simple lesson. So this is the result with you get essentially in the end when you get to lat long, find the road, at a distance between is and whether into a party

line and then floating on a map. Thank you guys.

Cackle comments for the website

Buy this talk

Access to the talk “PGConf India 2020 - Lightning Talk - Routing in Postgres - Sangarshanan - Grofers”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Standart

Get access to all videos “PGConf India, 2020”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ticket

Interested in topic “IT & Technology”?

You might be interested in videos from this event

September 28, 2018
Moscow
16
179
app store, apps, development, google play, mobile, soft

Similar talks

Ashutosh Bapat
Senior PostgreSQL Architect at EDB
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ajay Kumar
Assistant Engineer at Kerala State Electricity Board
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Anastasia Lubennikova
Database Developer at Postgres Professional
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Buy this video

Video

Access to the talk “PGConf India 2020 - Lightning Talk - Routing in Postgres - Sangarshanan - Grofers”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Conference Cast

With ConferenceCast.tv, you get access to our library of the world's best conference talks.

Conference Cast
816 conferences
32658 speakers
12329 hours of content