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 anandology@gmail.com
 designates 209.85.142.188 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=F9w50uFHvS/UC6OxyN9S+HW/Pjo6veFLbU9zp6444gZ3nv6TlizgJ9WvndvB/X7Ksq
         9+GkvtrsWxgI8+8LX3f4g2cKTZ0XyU4ZOh7V69dV8DoqJ5loV35WBqhO2XSwr++ffs4m
         NP7YsEjhPzfTSTaTzy0u/0/PbV3o7s8svOce4=
MIME-Version: 1.0
Date: Fri, 13 Mar 2009 17:29:57 +0530
Message-ID: <41139fcb0903130459td4f3d40ic4f418d7842c14ba@mail.gmail.com>
Subject: equivalent of JOINs in couchdb?
From: Anand Chitipothu <anandology@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi,

I have been reading about couchdb and trying understand how it works.
One thing that i'm unable to understand is how to do equivalent of
JOINs in couchdb.

Let me explain what I need with an example.
I want to store books in couchdb with each book having title, authors,
isbn, lccn, publisher and many other fields.
I would like to be able to query the system for any combination of
these. some thing like:

type="book" and publisher="foo" and author="bar
type="book" and isbn="1234567890"

How to do this in couchdb?
I wouldn't want to create a temporary view for running each query as
it is very expensive.

Thanks,
Anand