Re: postgres with graph model - Mailing list pgsql-general

From Philipp Kraus
Subject Re: postgres with graph model
Date
Msg-id BAC388E4-10FD-492C-A2C8-4C32B23D9B56@tu-clausthal.de
Whole thread Raw
In response to Re: postgres with graph model  (Fabrízio de Royes Mello <fabrizio@timbira.com.br>)
List pgsql-general
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 <fabrizio@timbira.com.br>:


Em qui, 19 de abr de 2018 às 11:54, Philipp Kraus <philipp.kraus@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,

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

pgsql-general by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: postgres with graph model
Next
From: Thomas Kellerer
Date:
Subject: Re: postgres with graph model