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 nicpottier@gmail.com
 designates 209.85.160.56 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;
        b=TO/zYakDCncZ4Gcu7Hb4zxQdSzlaNxrPba9WY0656SQqB/1W1iQNsI3C0zqfwc08qk
         n7jWxC+oeRLvd+J9745NAs8BlcFDYLiRpRoiS9qSrOsoN/GNFocOPvM/NuEfxE29QFhy
         1RtK5nEN7sdubZDU4cPRLYSAMTphAF1uB+jLc=
MIME-Version: 1.0
Date: Wed, 6 Jan 2010 10:10:27 -0800
Message-ID: <f334ade01001061010ka48f05fh9f0cda30122b4a4c@mail.gmail.com>
Subject: Building IFI View for Text Queries
From: Nic Pottier <nicpottier@gmail.com>
To: user <user@couchdb.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

Howdy All,

New user playing with CouchDB to evaluate whether it will work for our
needs.  I have a good bit of experience with standard SQL and recently
with Amazon's SimpleDB, but I'll admit my brain is stretching a bit to
get the 'couch db' way of doing things.

Anyways, in my particular case, I have a set of records, let's say
they are websites, which have an id of their URL, and various
attributes, including the 'title' of the URL.

I want the ability to be able to find all sites which contain a
particular word in their title.  I know that isn't directly supported
in couch-db, and that there is a Lucene 'add on', but I'd rather avoid
that if possible.

What I have tried is to create a view that is built by doing basic
tokenization of the titles, emitting each individual word in lowercase
with a null value.  Once created this acts as an inverted file index,
allowing me to find all the documents that contain a particular word
etc..  And it seems to work ok, it is fast, and updating documents
seems reasonably fast as well.  I can also do 'OR' queries using the
keys POST call on the view, which satisfies my requirements perfectly.

What's the catch?  Is this ok to do?  Any gotchas I should be aware of?

Thanks,

-Nic