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: local policy)
Message-ID: <49BCF1AF.5020706@proven-corporation.com>
Date: Sun, 15 Mar 2009 19:16:47 +0700
From: Jason Smith <jhs@proven-corporation.com>
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: equivalent of JOINs in couchdb?
References: <41139fcb0903130459td4f3d40ic4f418d7842c14ba@mail.gmail.com>
 <094453DE-AFFD-4905-A2F3-4A35304BC1FA@apache.org>
In-Reply-To: <094453DE-AFFD-4905-A2F3-4A35304BC1FA@apache.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Jan Lehnardt wrote:
>> 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?
> 
> http://www.cmlenz.net/archives/2007/10/couchdb-joins

I would also suggest looking at the couchdb-lucene project:

http://github.com/rnewson/couchdb-lucene/tree/master

I found that it's pretty easy to get up and running, and it seems to 
index your documents based on their top-level keys.  So your example of 
searching "type:book publisher:foo author:bar" might fit quite well.

(Also, sorry to post across threads, but ISBN is most certainly *not 
necessarily unique* per book!  It may be unique for a title (i.e. some 
text by some author distributed by some publisher), but of course all 
printings of that title have the same ISBN.  For example, a book 
inventory application may opt to use one document per book, thereby 
having several documents with the same ISBN.)

-- 
Jason Smith
Proven Corporation
Bangkok, Thailand
http://www.proven-corporation.com