incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Shepelev <temo...@gmail.com>
Subject Re: CouchDB for logging & file storage
Date Mon, 22 Jun 2009 14:46:50 GMT
>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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message