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.46.30 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=m/JKzTog7YLjGjTtDJtTk99dbNSMyM15UpUkIpZAGXhF6bMuOeF5qRLp8FzUhtgLff
         I22/gs0RT32N8igDNbJzhaIrJk4AVg1vsD4usn3QHhnUz8WOkJC4Nf1zMmd5UyJDT1HU
         uueme8OxDw+7b0XQJPGnx+i1hagWurg06NyQE=
MIME-Version: 1.0
In-Reply-To: <a95d32b00902240728h15b8ad7dyda7615ba578aa483@mail.gmail.com>
References: <a95d32b00902240728h15b8ad7dyda7615ba578aa483@mail.gmail.com>
Date: Tue, 24 Feb 2009 10:41:00 -0500
Message-ID: <e2111bbb0902240741v73b05378jbb2c6bcd9f5c157c@mail.gmail.com>
Subject: Re: Sphinx and CouchDB Views
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

I've spent alot of time looking through various approaches at FTI. The
biggest problem with Sphinx is that it requires you to provide a
unique 32 or 64bit integer as a document id. The impedance mismatch
with CouchDB's arbitrary string document id's has provided a bit of a
blocker for full on integration with Sphinx in the arbitrary case.

I've got entirely too many different attempts for full text indexing
on github [1], but the real one to keep an eye on is probably Robert
Newson's fork of my CouchDB-Lucene [2] branch. He's taken it quite a
long way and as soon as he's integrated Rhino I'm gonna close up all
of my rather half baked attempts.

HTH,
Paul Davis

[1] http://github.com/davisp
[2] http://github.com/rnewson/couchdb-lucene/tree/master


On Tue, Feb 24, 2009 at 10:28 AM, Adam Groves <adam.groves@gmail.com> wrote:
> Hi all,
>
> I read somewhere on the mailing list that Sphinx could be used to
> provide fti for couchdb views. Has anyone implemented this? Would you
> recommend it? Care to share some details? :)
>
> Cheers
>
> Adam
>