Re: Modeling Friendship Relationships - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Modeling Friendship Relationships
Date
Msg-id 20141120152513.GJ1639@alvin.alvh.no-ip.org
Whole thread Raw
In response to Modeling Friendship Relationships  (Robert DiFalco <robert.difalco@gmail.com>)
List pgsql-general
Robert DiFalco wrote:
> I have a question about modeling a mutual relationship. It seems basic but
> I can't decide, maybe it is 6 of one a half dozen of the other.
>
> In my system any user might be friends with another user, that means they
> have a reciprocal friend relationship.
>
> It seems I have two choices for modeling it.

Have you considered having an array with all friends of each person?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: better architecture?
Next
From: zach cruise
Date:
Subject: Re: better architecture?