Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cassandra-user@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates
 74.125.82.47 as permitted sender)
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:content-transfer-encoding;
        b=mY9PsLfcCpuRurkIYko+ICcQ4dXVboF9jUFz1fqEoODEChbeAscGmGgn71q9TyMisM
         1pzOxZ2F1Mw8/UfJvo16aUakA1Ruk/W70b45CbD4BgqNvJut1A7pDB4/SgsXJztvkuMY
         zCGvfy2s5KwgJSV32CwCQW1qN4Bof8unx9E3M=
MIME-Version: 1.0
In-Reply-To: <badc6e0f1002011910h1c1c9da9tdee380dfb2dfc4@mail.gmail.com>
References: <badc6e0f1002011910h1c1c9da9tdee380dfb2dfc4@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Mon, 1 Feb 2010 21:27:57 -0600
Message-ID: <e06563881002011927r2df50bc4m836ccdffb88040c3@mail.gmail.com>
Subject: Re: Multiblog Scenario: Schema Design
To: cassandra-user@incubator.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

You would add a columnfamily with a row per month and write blog posts
(either ids or entire post data) to that CF.

On Mon, Feb 1, 2010 at 9:10 PM, Rockett Williams
<rockett.williams@gmail.com> wrote:
> Most people are aware of Evan Weaver's (from Twitter) blog post introduci=
ng
> Cassandra.
> http://blog.evanweaver.com/articles/2009/07/06/up-and-running-with-cassan=
dra/
> In the post he uses a example multiblog=A0application=A0-> a blog for mul=
tiple
> users.
> I was wondering how would you be able to query by date for the example wh=
ich
> would be a common scenario.
> For example, I want all blog posts from the month of January.
> What schema changes would be required and how would you=A0approach=A0the =
problem
> using the API.