[GraphHopper] Postgres/PostGis Integration

[Peter K]

Hi Mark,

> Hi All
>
> Graphhopper is quite impressive. We have been considering PgRouting
> for our database (we have our own map and also OSM) and not being java
> folks, would like to ask the obvious question before spending a lot of
> time:
>
> Q: Can graphhopper route against a Postgres/PostGis database easily or
> does it need to be modified extensively

I don't think that this is a good idea. I'm not sure how pgrouting it
does but probably they don't access the data via the normal SQL queries
and use a direct database access somehow. Otherwise if you need to hit
some indices to get neighbor nodes for every node while traversing this
would be horribly slow.

But yes, graphhopper can be modified to use different datasource. I've
done similar things like this one year before for a graph database
called neo4j but it isn't that easy and everything else will be slower
then the in-memory access. Also it isn't that easy i.e. you need to
understand graphhopper internals and Java a bit.

Regards,
Peter.