Re: some questions

[Adam Jacob <adam@opscode.com>]

On Thu, Apr 23, 2009 at 12:45 AM, David Lee <david.lee@kanji.com.au> wrote:
>> I'm not sure I understand how the search indexes help solve Miguel's
>> problem?
>
> I was just curious about how difficult the implementation is likely to be.
> An ActiveRecord, with polymorphic joins etc, would likely require less work
> than one using native database interaction.
>
> But I gather it would have to be built directly on top of couch; I have
> little sense of the difficulty involved at this point, and I'm curious.

CouchDB is particularly ill-suited to ad-hoc queries of that sort -
while you would be easily able to pull out single objects, you really
don't have the ability to string together arbitrary queries in the way
you are thinking.  This is a side-effect of being schema-free and
document oriented, and it's why something like a full text index for
the CouchDB documents is necessary.

We're chatting about ways to make this better in the long term - we
would love to hear your thoughts on the matter.

Adam

-- 
Opscode, Inc.
Adam Jacob, CTO
T: (206) 508-4759 E: adam@opscode.com