Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
Date: Fri, 19 Mar 2010 16:28:00 -0700
Message-ID: <40eb52621003191628h2e9ebbd0k4d6eefbb12155426@mail.gmail.com>
Subject: ANDing of tags
From: Eric Jonas <jonas@ericjonas.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1

I know this question has come up before, and the answer has often been
"do multiple queries and do the intersection client-side". But there
were also discussions about possibly adding this functionality to
couchdb.

I have a document archive with up to 100k documents, each of which has
a 'tags' field consisting of a list of string-based tags like so:

{ tags: ['hello', 'world', 'testing']}

I would like to let my users search for documents containing all of
some subset of the tags. For example, "all documents containing the
tag 'hello' and 'world'". It's the logical _and_ there that continues
to vex. Doing the conjunction on the client would be problematic for
very popular tags, potentially necessitating the download of tens of
thousands of documents.

Is there any reasonable way to appropriately create a view to make
this operation less painful?

Thanks!
    ...Eric