Create a nested ratings/comments feature like reddit

Neo4j Graph Platform Cypher
1

hi,

We have rating/comments functionality with below structure..

(User)-[r:ratings{comments info}]->(Object)..

Now we are looking to allow user to reply/comments of these ..like a nested conversation..

Looking for inputs on modeling this using nested relationships, paths and depths..but again i don't to create a flood of nodes for ratings/comments..

Thanks in advance.

2

Hey @sivakura, why don't you create node for the rating object. Like,
(User)<-[:From]-(Rating {comments : info})-[:To]->(Object).
And for conversation create a new relation of reply which store the time stamp of the reply time, so you can sort conversation according to the time sort. Like,
(User)-[:Reply {timestamp}]->(Rating)

3

Thanks Rushikesh. But replies can have replies and on ..

4

In that case, create a relation between user and user node