Re: postgres with graph model

From: Philipp Kraus <philipp(dot)kraus(at)tu-clausthal(dot)de>
To: Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres with graph model
Date: 2018-04-19 16:46:44
Message-ID: BAC388E4-10FD-492C-A2C8-4C32B23D9B56@tu-clausthal.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)timbira(dot)com(dot)br<mailto:fabrizio(at)timbira(dot)com(dot)br>>:

Em qui, 19 de abr de 2018 às 11:54, Philipp Kraus <philipp(dot)kraus(at)tu-clausthal(dot)de<mailto:philipp(dot)kraus(at)tu-clausthal(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2018-04-19 17:21:00 Re: postgres with graph model
Previous Message Fabrízio de Royes Mello 2018-04-19 16:42:29 Re: postgres with graph model