Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 35167 invoked from network); 20 Sep 2010 10:14:05 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 20 Sep 2010 10:14:05 -0000 Received: (qmail 47837 invoked by uid 500); 20 Sep 2010 10:14:03 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 47726 invoked by uid 500); 20 Sep 2010 10:14:00 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 47716 invoked by uid 99); 20 Sep 2010 10:14:00 -0000 Received: from Unknown (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Sep 2010 10:14:00 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of vineetdaniel@gmail.com designates 209.85.216.179 as permitted sender) Received: from [209.85.216.179] (HELO mail-qy0-f179.google.com) (209.85.216.179) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Sep 2010 10:13:39 +0000 Received: by qyk9 with SMTP id 9so4335900qyk.10 for ; Mon, 20 Sep 2010 03:13:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:content-type; bh=ZqvL/NM3yO8vfwzXYO9tp8mdNTCmtzSL9EbBszEJDas=; b=ad4eE3icjM+8vHtlhT4ZQD/IJ+u2onGAG0mVuz/0156IQR0JlQBo5GA3UTQzoCemUu KGrCTWITpNJpVk/4u4PDFQii3FukJt7gs7sgcTisWUY4wKzKtJUpD44TvBT5o99Pp3/x hLXKzK12ZXRUo2nyvjmJaO61fFovYZj8XlGYo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=ReoYkuHJ5z49r38WegxX6x1G97dtbpTgTvSquSpvRscYvZnIPuFrXRw1LcsIVVVFnn 9v2rjnqjgmHo/vqI2niWCQsWSHONk2La/YHZV77w4HP9BhKNPuVSWE1Xdr6HGYOv3sZ5 SIm4IKdtmdouYU0AX39EfnNonMMrqWEyWjS8k= Received: by 10.229.11.8 with SMTP id r8mr5621690qcr.236.1284977598500; Mon, 20 Sep 2010 03:13:18 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.235.136 with HTTP; Mon, 20 Sep 2010 03:12:56 -0700 (PDT) In-Reply-To: <8591FF03-6316-46B6-9BAE-176545116928@thelastpickle.com> References: <4C973026.8020203@monit.dk> <8591FF03-6316-46B6-9BAE-176545116928@thelastpickle.com> From: vineet daniel Date: Mon, 20 Sep 2010 15:42:56 +0530 Message-ID: Subject: Re: Schema question To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=0016364ed4524d91710490ae2921 X-Virus-Checked: Checked by ClamAV on apache.org --0016364ed4524d91710490ae2921 Content-Type: text/plain; charset=UTF-8 Hi Morten Simplest appraoch that comes to my mind (without considering any other use -cases just read and unread messages) is to use two CF's 'read' and 'unread', put all new messages in 'unread' and once user reads any one one them shift the same to 'read' and mark original for deletion. Regards Vineet Daniel Cell : +918106217121 Websites : Blog | Linkedin | Twitter On Mon, Sep 20, 2010 at 3:35 PM, aaron morton wrote: > Here is a discussion about implementing twitter with Cassandra > http://www.rackspacecloud.com/blog/2010/05/12/cassandra-by-example/ > > An example of the same on github > http://github.com/ericflo/twissandra > > If you have not done already checkout the articles page on the wiki > http://wiki.apache.org/cassandra/ArticlesAndPresentations > > Aaron > > > On 20 Sep 2010, at 21:57, Morten Wegelbye Nissen wrote: > > > Hello List, > > > > No matter where you read, you almost every-where read the the noSQL > datascema is completely different from the relational way - and after a > little insight in cassandra everyone can 2nd that. > > > > But I miss to see some real-life examples on how a real system can be > modelled. Lets take the example for a system where users can send messages > to each other. ( Completely imaginary, noone would use cassandra for a > mailsystem :) ) > > > > If one should create such a system, what CF's would be used? And how > would you per example find all not read messages? > > > > ./Morten > > --0016364ed4524d91710490ae2921 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Morten

Simplest appraoch that comes to my mind (without consideri= ng any other use -cases just read and unread messages) is to use two CF'= ;s 'read' and 'unread', put all new messages in 'unread= ' and once user reads any one one them shift the same to 'read'= and mark original for deletion.


Regards
Vineet Daniel
Cell=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : +918106217121=
Websites :
Blog =C2=A0 = |=C2=A0=C2=A0 Linkedin=C2=A0 |=C2=A0 Twitter



On Mon, Sep 20, 2010 at 3:35 PM, aaron m= orton <aaro= n@thelastpickle.com> wrote:
Here is a discussion about implementing twitter with Cassandra
http://www.rackspacecloud.com/blog/2010/05/12/cassan= dra-by-example/

An example of the same on github
http://g= ithub.com/ericflo/twissandra

If you have not done already checkout the articles page on the wiki
http://wiki.apache.org/cassandra/ArticlesAndPresentations<= br>
Aaron


On 20 Sep 2010, at 21:57, Morten Wegelbye Nissen wrote:

> Hello List,
>
> No matter where you read, you almost every-where read the the noSQL da= tascema is completely different from the relational way - and after a littl= e insight in cassandra everyone can 2nd that.
>
> But I miss to see some real-life examples on how a real system can be = modelled. Lets take the example for a system where users can send messages = to each other. ( Completely imaginary, noone would use cassandra for a mail= system :) )
>
> If one should create such a system, what CF's would be used? And h= ow would you per example find all not read messages?
>
> ./Morten


--0016364ed4524d91710490ae2921--