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 mwkohout@gmail.com designates
 209.85.214.52 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;
        b=RhagzY44Mwxu1s4IMx1Ee5tKpZ4x99uY6iWSOOiPsQNKOsk//4SiZ++0XfbnJ3/gu6
         czBLZiFlhhoyM0c//zu8SmBbVEGx/Bna5/5dLMeI8wLRgrl1bh1aV2kXXG7UJ/xvXPVj
         V0pwVqxHHY8GtxmHLYYfPSrffFHr+P9C/lxOc=
MIME-Version: 1.0
In-Reply-To: <AANLkTi=eQx7KGoMpQ_2zS6nFzo0XOnd1Zxse1pS=+e1d@mail.gmail.com>
References: <AANLkTikc7ATPf3Dm5Egmmk6ouvt-FeCPQhJY-XZQxmCL@mail.gmail.com>
	<AANLkTi=eQx7KGoMpQ_2zS6nFzo0XOnd1Zxse1pS=+e1d@mail.gmail.com>
Date: Mon, 7 Feb 2011 14:28:49 -0600
Message-ID: <AANLkTincY_e4EPKX-6AQ2xWNo+Qu9nCT_ppWkWXqodt-@mail.gmail.com>
Subject: Re: new couch user: "denormalizing" using views? General application
 architecture suggestions?
From: Michael Kohout <mwkohout@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=00504502d60c5aec6f049bb71490

--00504502d60c5aec6f049bb71490
Content-Type: text/plain; charset=ISO-8859-1

I'd rather not do it via batch because I'd like the system to be interactive
(via a browser).  And depending on all this processing to occur outside this
subsystem seems less robust.  And to touch on your point, this is a pretty
big database and exporting like that would make some unhappy dbas.  I'm not
sure these are good reasons, but at least they are the ones I've thought of.

But ultimately what I've taken from this conversation is that the _changes
feed is basically the only way I can build the system I'd like.  Unless
there is some other way that makes sense.

thanks
Mike


On Mon, Feb 7, 2011 at 11:29 AM, Dirkjan Ochtman <dirkjan@ochtman.nl> wrote:

> On Mon, Feb 7, 2011 at 18:14, Michael Kohout <mwkohout@gmail.com> wrote:
> > What does the couch community think of this?  Is there some other pattern
> > that might result in a simpler system?
>
> Simple system: use SQL JOINs to fetch all the data for each document
> you want in CouchDB, then batch-load those into CouchDB (per few k
> documents) as the rows come in from the RDBMS.
>
> I'm not sure why you'd want to do it some other way? This is the way
> I've done it a few times, though admittedly on smaller databases. I
> don't think your idea for doing joins in a view is particularly
> feasible, though there are things you can do here.
>
> Cheers,
>
> Dirkjan
>

--00504502d60c5aec6f049bb71490--