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 kxepal@gmail.com designates
 209.85.212.173 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CA+T+PjFBuoNY-aHBkvpzwCwjFpVMUjwRY0ztt7F19FqkxuD0Nw@mail.gmail.com>
References: 
 <CA+T+PjFBuoNY-aHBkvpzwCwjFpVMUjwRY0ztt7F19FqkxuD0Nw@mail.gmail.com>
Date: Wed, 1 Oct 2014 23:03:59 +0400
Message-ID: 
 <CAHdjipKM6GRr0pErmvAeZr35pc1FixokqzV=AV9QRyu=LD1Qhg@mail.gmail.com>
Subject: Re: How to store the delta between doc revisions?
From: Alexander Shorin <kxepal@gmail.com>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Content-Type: text/plain; charset=UTF-8

Storing patches is good until you're in sure that no single patch will
get suddenly deleted. Otherwise you could easily find all your history
broken. Oblivious, but it is the thing to remember when picking this
way of history management. Storing full document copies per revision
is more solid solution for such case: you can easily skip or lose one
or several revisions and be fine, but it also consumes much more disk
space. Trade offs are everywhere, pick up the one that suites you.
--
,,,^..^,,,


On Wed, Oct 1, 2014 at 10:02 PM, Eric B <ebenzacar@gmail.com> wrote:
> I'm new to CouchDB and trying to figure out the best way to store a history
> of changes for a document.
>
> Originally, I was thinking the thing that makes the most sense is to use
> the update function of CouchDB but not entirely sure if I can.  Is there
> someway to use the update function and modify/create a second document in
> the process?
>
> For example, if I have a document which contains notes for a client.
> Everytime I modify the notes document (ie: add new lines or delete lines),
> I want to maintain the changes made to it.  If there was a way to use
> CouchDB's rev fields for this, my problem would be solved, but since
> CouchDB deletes non-current revs upon compaction, that is not an option.
>
> So instead, I want to create a "history_log" document, where I can just
> store the delta between documents (as a patch, for example).
>
> In order to do this, I need to have my existing document, my new document,
> compare the changes and write them to a history_log document.  But I don't
> see if/where I can do that within and update handler.
>
> Is there something that can help me do this easily within CouchDB?  Are
> there patch or json compare functions I can have access to from within a
> CouchDB handler?
>
> Thanks,
>
> Eric