8
aaxa
6y

I've now spent 6 hours trying to find a way to do something similar, as you can do in Neo4j, where you find relations up to depth 5, in PostgreSQL.
The issue is, I have to tables. One with persons, another one with relations (incoming ID and outgoing ID) to have a many to many relationship.

I'm at the point where I just don't care getting it to work. In Neo4j it's a fucking one liner, so why the fuck am I getting assigned to do this in PostgreSQL?
To prove a point? Well fuck you, I'm done with this shit.

Comments
  • 1
    have a look into closure tables... might help you!

    http://technobytz.com/closure_table...
  • 1
    @sergiolarosa89 I absolutely love Neo4j
  • 2
    @sergiolarosa89
    I'm actually doing something very similar.

    Right now, I've made a query to go for depth 5 in PostgreSQL. My Docker container crashed, and the JVM is NOT happy when I run it locally. I wonder if the PostgreSQL benchmark will ever be done.

    On depth 5 the absolute max query time is 45 seconds in Neo4j.
Add Comment