Re: postgres with graph model

[Thomas Kellerer]

Philipp Kraus schrieb am 19.04.2018 um 16:53:

I’m using in a project Postgresql and PostGIS for a geospatial data
model, but now I need also a graph in this structure, so my question
is, is there any existing extension for Postgres to build a graph. I
found ltree but this is for tree structures only, not for graphs. In
general I have different undirected weighted graphs. So I need some
routing algorithms based on the graph weights, distance calculation
between nodes. My first idea was to use a graph database e.g neo4j,
but I have got a limitation, that the whole system should be designed
in Postgres. 
Did you can give some ideas to build a graph within Postgres?


There is a Postgres fork that claims to combine the graph and relational world

http://bitnine.net/agensgraph

Re: postgres with graph model

[Philipp Kraus]

Thanks,

seems to be a good idea, but I need some routing on geo position data, but also 
some graph algorithm depends on machine learning structures,
if I can use the pgRouting project to deal with a „feature graph“ and 
geo-partial data this will be great, I will test it

Thanks for this hint

Am 19.04.2018 um 18:42 schrieb Fabrízio de Royes Mello 
>:


Em qui, 19 de abr de 2018 às 11:54, Philipp Kraus 
> escreveu:
Hello,

I’m using in a project Postgresql and PostGIS for a geospatial data model, but 
now I need also a graph in this structure, so my question is, is there any 
existing
extension for Postgres to build a graph. I found ltree but this is for tree 
structures only, not for graphs. In general I have different undirected 
weighted graphs. So
I need some routing algorithms based on the graph weights, distance calculation 
between nodes. My first idea was to use a graph database e.g neo4j, but I have
got a limitation, that the whole system should be designed in Postgres.
Did you can give some ideas to build a graph within Postgres

Do you already check the pgrouting [1] project?

Regards,

[1] http://pgrouting.org/
--
   Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Re: postgres with graph model

[Fabrízio de Royes Mello]

Em qui, 19 de abr de 2018 às 11:54, Philipp Kraus <
philipp.kr...@tu-clausthal.de> escreveu:

> Hello,
>
> I’m using in a project Postgresql and PostGIS for a geospatial data model,
> but now I need also a graph in this structure, so my question is, is there
> any existing
> extension for Postgres to build a graph. I found ltree but this is for
> tree structures only, not for graphs. In general I have different
> undirected weighted graphs. So
> I need some routing algorithms based on the graph weights, distance
> calculation between nodes. My first idea was to use a graph database e.g
> neo4j, but I have
> got a limitation, that the whole system should be designed in Postgres.
> Did you can give some ideas to build a graph within Postgres


Do you already check the pgrouting [1] project?

Regards,

[1] http://pgrouting.org/

> --
   Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

postgres with graph model

[Philipp Kraus]

Hello,

I’m using in a project Postgresql and PostGIS for a geospatial data model, but 
now I need also a graph in this structure, so my question is, is there any 
existing
extension for Postgres to build a graph. I found ltree but this is for tree 
structures only, not for graphs. In general I have different undirected 
weighted graphs. So
I need some routing algorithms based on the graph weights, distance calculation 
between nodes. My first idea was to use a graph database e.g neo4j, but I have
got a limitation, that the whole system should be designed in Postgres.
Did you can give some ideas to build a graph within Postgres?

Thanks

Phil