Just a small question to the graph DB experts out there:
What is the best way to separate confirmed and unconfirmed friendships in neo4j? As the relations are only unidirectional I see three ways:
1) Use one single relation and add a flag like “isConfirmed”
2) Use two relations: A and B are friends as soon the relations A->B AND A<-B exist
3) Use two different types of relation: “RequestdFriendship” and “IsFriendOf”. So as soon as the request is confirmed I would delete the RequestedFriendship and create IsFriendOf which direction will be ignored.
So what is the most performant way?