Re: Is Cake capable of building up a small or medium social network?

I don't recommend this approach because if you want to know all user 1 friends yo must do something like

user_id_1=1 or user_id_2=1 and thats an overhead (and you need two indexes for that)

if you have something like:

Table friends:

id   user1_id user2_id

1       1            2

1       2            1
2       5            2

2       2            5
3       3            1

3       1            3
4       4            1

4       1            4
5       2            4

5       4            2

you can do  user_id_1=1 (only one index)

Regards

Pablo Viojo
pviojo@gmail.com
http://pviojo.net

¿Que necesitas?
http://needish.com

On Thu, Aug 27, 2009 at 2:48 PM, DigitalDude <e.blumstengel@googlemail.com> wrote:

Hey,

ah ok I think we both mean the same thing, but I forgot that the
relation is not only by one side, but by two sides.

So a simple example would look like this:

Table friends:

id   user1_id user2_id

1       1            2
2       5            2
3       3            1
4       4            1
5       2            4

This would mean:

User 1 is a friend of: 2, 3 and 4
User 2 is a friend of: 1, 4 and 5
User 3 is a friend of: 1
User 4 is a friend of: 1 and 2
User 5 is a friend of: 2

Is that correct? I think it is...?

On 27 Aug., 18:33, Miles J <mileswjohn...@gmail.com> wrote:
> Not necessarily. If you are doing a friend system, the table would
> look like so:
>
> friends: id, user1_id, user2_id
>
> And 1 row would be for both user1 and user2, instead of adding 2 rows
> for each user.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---