Re: [sqlite] Multiple relations

2011-06-14 Thread BareFeetWare
On 14/06/2011, at 8:29 PM, Ian Hardingham wrote: > Guys, I have another DB design question. Have you implemented the normalisation we discussed before, yet, especially id integer primary key column for players? Otherwise, stop here. > I have 100 - 1 clients connected to my server. Is a

[sqlite] Multiple relations

2011-06-14 Thread Ian Hardingham
Guys, I have another DB design question. I have 100 - 1 clients connected to my server. Each client has a status. Many clients are "watching" *one* other client, which means that any change in that client's status must immediately be sent to the watching clients. Estimates of numbers: -