Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of djc.ochtman@gmail.com
 designates 209.85.212.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:from:date
         :x-google-sender-auth:message-id:subject:to:content-type;
        b=L3DNA7gncS86I/C6X0Ka3qStfwOmru14CPSazFKrQfLJDkrlMxiik1GYlv/HiNw91F
         rDA8YDt9KRmTmafE9saIjXZyMA0myHVoR651uY4zRDr98w7LX6MO1y/8RBXqYGLuWQRm
         wcoZqkH2fu+fM4vjfEk7lrrKCoWbsP0as6AKg=
MIME-Version: 1.0
Sender: djc.ochtman@gmail.com
In-Reply-To: <AANLkTik4VvkJnm1HbxJ4zXkqrZ_ONApwrK_tWHL9ABOT@mail.gmail.com>
References: <AANLkTi=YPG1+xFp8K=ML7EQhghG7XVpUgePiRJQ_BqNJ@mail.gmail.com>
 <AANLkTikg9eiumif1eQYsfwfd2ioTxpr9XNGYmT==PF2r@mail.gmail.com>
 <AANLkTik4VvkJnm1HbxJ4zXkqrZ_ONApwrK_tWHL9ABOT@mail.gmail.com>
From: Dirkjan Ochtman <dirkjan@ochtman.nl>
Date: Wed, 8 Dec 2010 13:47:09 +0100
Message-ID: <AANLkTi=siurE9aiG+iLARPUKtBbH6UAeCNvTFnVBJv_O@mail.gmail.com>
Subject: Re: Database design with CouchDB
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8

On Wed, Dec 8, 2010 at 13:34, He Shiming <heshiming@gmail.com> wrote:
> So one database for one project, and one document for a kind of data
> huh? That's very helpful, thank you very much.

That's not exactly what I was saying. I have one document per user.

> One follow up question. Why do you use marker fields for each
> document, as opposed to just use "user" as the key for the "user
> document"? Does this have any advantage in view design?

An example: this app has two users, you and me. Documents:

{"_id": "dirkjan", "name": ["Dirkjan", "Ochtman"], "type": "user"}
{"_id": "he", "name": ["He", "Shiming"], "type": "user"}

Now I can easily build views that take the "document type" into
account (get all users), and I can easily make an atomic update of all
information related to one user.

Hope that helps,

Dirkjan