Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of paul.joseph.davis@gmail.com
 designates 74.125.44.29 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:content-transfer-encoding;
        b=hIVxnwJKwybLpC/0vUuhSAd8K/kWQzIQNQSli68UNq902082cONcVYGux4Ok1/iv+X
         nQdjJXZ359hbdEnaylL4Z3NRW0prDuC/sSRm/kttrhizwPLDizWfbgAdp7/aVVtcdqQw
         pkJNuZB/k+QPVSNpj/S9BDtuwOXKjnRvIhyK4=
MIME-Version: 1.0
In-Reply-To: <99604707-9FBB-4C67-A408-A1046CDD6BBF@gmail.com>
References: <99604707-9FBB-4C67-A408-A1046CDD6BBF@gmail.com>
Date: Fri, 13 Mar 2009 16:12:46 -0400
Message-ID: <e2111bbb0903131312n43cf9d51h71f55d62f62c0c9f@mail.gmail.com>
Subject: Re: Relational data
From: Paul Davis <paul.joseph.davis@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Dmitrii,

The two recommended ways would either be to store the display_name in
the comment or use multi-get to fetch all user docs at once.

HTH,
Paul Davis

On Fri, Mar 13, 2009 at 4:03 PM, Dmitrii Dimandt <dmitriid@gmail.com> wrote:
> Yeah, I know, I know, relational data was never meant to be in CouchDB, but
> still...
>
> What would be the best way to handle the following situation:
>
> news: url, text
> comments: news_url, text, user_login
> user: display_name, user_login
>
>
> So, when I show a news item with comments, it means that I need to do a
> round trip to CouchDB for every comment in order to retrieve the user's
> display name. Is there a better way to do it?
>