Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of augustyn.michal@gmail.com
 designates 209.85.216.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=Kr5Wp4+lQ4P2i+AdcusN9QxiuWrl3H5KRhJbipF5fpoMYJnA1Gtc/BalWu2A42p3rZ
         Sj/DhG0Q7ZrkxWeMViAu/Ytxky7wykKaax7iLo3nMB+DxbzpCuLJEhQgmWIp+G6d4wGT
         qyY3Iw0fESDcWP77147Wqg7GFjMDmKwHrggeg=
MIME-Version: 1.0
In-Reply-To: <AANLkTi=cjq5vyyShrQnzYi0FY-7bJ-TXVEJhcr6ScU1Z@mail.gmail.com>
References: <AANLkTi=6bLtjCysSjCHTXbi9xxVJ=EQcCwWVt5WCXvB6@mail.gmail.com>
	<AANLkTi=cjq5vyyShrQnzYi0FY-7bJ-TXVEJhcr6ScU1Z@mail.gmail.com>
Date: Tue, 15 Feb 2011 14:12:32 +0100
Message-ID: <AANLkTi=PRNTRMR6pVOTZaChvc=u0sbSs=cdP0cgmTFzK@mail.gmail.com>
Subject: Re: online chat scenario
From: =?ISO-8859-1?Q?Michal_August=FDn?= <augustyn.michal@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=00163628410cccd738049c51eaf8

--00163628410cccd738049c51eaf8
Content-Type: text/plain; charset=ISO-8859-1

The schema design depends on chatrooms/users/messages numbers. I.e. you can
have one CF, where key is chatroom, column name is username, column value is
the message and message time is the same as column timestamp.
You can add day-timestamp to the chatroom name to avoid large rows.

Augi

2011/2/15 Andrey V. Panov <panov.andy@gmail.com>

> I never did it. But I suppose you can use "chatroom name" as key and store
> messages & nicks as columns in JSON and timestamp as columnName.
>

--00163628410cccd738049c51eaf8
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

The schema design depends on chatrooms/users/messages numbers. I.e. you can=
 have one CF, where key is chatroom, column name is username, column value =
is the message and message time is the same as column timestamp.<div>You ca=
n add day-timestamp to the chatroom name to avoid large rows.<br>
<div><br></div><div>Augi<br><br><div class=3D"gmail_quote">2011/2/15 Andrey=
 V. Panov <span dir=3D"ltr">&lt;<a href=3D"mailto:panov.andy@gmail.com">pan=
ov.andy@gmail.com</a>&gt;</span><br><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I never did it. But I suppose you can use &quot;chatroom name&quot; as key =
and store messages &amp; nicks as columns in JSON and timestamp as columnNa=
me.<br>
</blockquote></div><br></div></div>

--00163628410cccd738049c51eaf8--