About the talk
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
Buy this talk
Buy this video
With ConferenceCast.tv, you get access to our library of the world's best conference talks.