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 mrtrick@gmail.com designates
 209.85.161.180 as permitted sender)
Message-ID: <4EB7DC56.9000004@gmail.com>
Date: Tue, 08 Nov 2011 00:25:42 +1100
From: Patrick Barnes <mrtrick@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1;
 rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: Best way to model historical data
References: 
 <CABBNpWsxpOvEehY7qx+iqXSUmiQ=PmW_j4ysrypkLXuWHWT9qQ@mail.gmail.com>
In-Reply-To: 
 <CABBNpWsxpOvEehY7qx+iqXSUmiQ=PmW_j4ysrypkLXuWHWT9qQ@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi Andres,

For your historical data; do you need to run all the same levels of 
queries on it? Or would you be more likely to only need the historical 
data so that you can undo changes?

For the latter case, consider if storing a copy of the previous versions 
of a document as a json attachment could work well for you. You could 
still access those earlier versions through the current document, but it 
would not end up appearing in your views. If you need to revert to an 
older version of the document, store the current version and load the 
older version into the document.

Regards,
-Patrick

On 2/11/2011 9:20 PM, couchdb - Andr�s Orencio - lodopidolo wrote:
> Hello. I'm new in couchdb.
>
> I have some questions but I'm going to put them in separate threads.
>
> For this, I want ask you which is the better way to store documents and its
> historical states.
>
> For example, I have products documents and categories documents. Products
> has one or more categories. This "relation" may change in the time, and
> product characteristics can change to.
>
> I want to store all document changes (categories too).
>
> Which is the better way to do this?
>
> Thanks you.
>