Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of robert.newson@gmail.com
 designates 209.85.218.218 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=btW/xftnswqQgXfDgni5rCSUWexAA6HV8DNEl7+h8O9AK1h24QIQgKbeGfzaGmcbo+
         boXn9HJklvZ+INGWwC5dh1iBfRlyslz61y/5AOEo5O2tqi9LlI195Jk+2gyb3fdIRfoO
         bJoKiChStfJEoSnxYWhybFa2dQjG3nlQoZwXE=
MIME-Version: 1.0
In-Reply-To: <2d8fb9950906220746u2fb59ab2w6c463cd8732b671a@mail.gmail.com>
References: <-8441383996293842423@unknownmsgid>
	 <2d8fb9950906220746u2fb59ab2w6c463cd8732b671a@mail.gmail.com>
Date: Mon, 22 Jun 2009 16:29:45 +0100
Message-ID: <46aeb24f0906220829r408f085bv8de237e58860204f@mail.gmail.com>
Subject: Re: CouchDB for logging & file storage
From: Robert Newson <robert.newson@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

You can also pass stale=ok if you don't need the latest results from a view.

http://wiki.apache.org/couchdb/HTTP_view_API

B.

On Mon, Jun 22, 2009 at 3:46 PM, Sergey Shepelev<temotor@gmail.com> wrote:
> From my poor experience with couch, i think that your task (ever expanding
> set of data, no updates) is perfect for couch.
> But, you should
> also consider that expanding-only set of data is a good task for
> constant databases too. Though, you would run into a expansive process
> writing a nice querying layer on top of key-value CDB.
>
> You can do basic and somewhat advanced querying with couch, though, full
> text searching is not here. (Again, my knowledge is poor, maybe FTS is
> possible)
> Consider also, that couch indexing is lazy, it doesn't index documents until
> you ask it a query.
>
> AND, the most difficult (for me) part - query is blocking on indexing. You
> won't have any results until whole database is indexed. Index results are
> cached, so old documents aren't processed until they changed. But for new
> type of query and database with 300K items you will wait tens minutes to
> hours to get query result.
>
> But you can run a tiny daemon that does query few times a minute so you
> always have fast queries with up-to-date data.
>
> On Mon, Jun 22, 2009 at 6:01 PM, Nitin Gupta <nitin.gupta@srishtitechnet.com
>> wrote:
>
>> Hi All,
>>
>>
>>
>> I am new to non-rdbms storage systems. I am working on an application in
>> which we need to log different user actions as plain text. I am not of the
>> opinion to make use of our rdbms for this activity as writing this on a
>> rdbms can be an expansive process.
>>
>>
>>
>> Can I make use of Couch DB for this activity? Also I am looking to store
>> all
>> the attachments or BLOB into some non-rdbms solution. Can I make use of
>> CouchDB here as well. This way I will just have to add one network
>> component
>> to address file storage and logging of user action.
>>
>>
>>
>> I would probably need to show the logged information on the admin console
>> or
>> some other UI to the users. I hope that I can do basic indexing, querying
>> etc on the basis of data items.
>>
>>
>>
>> Regards,
>>
>> nitin
>>
>>
>