couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kowsik <>
Subject Re: Getting a top 10 list by a calculated value
Date Tue, 06 Oct 2009 04:10:47 GMT
If you have the user and comment as separate docs (with the user_id in
the comment doc), then the simple way is to update the user doc each
time s/he makes a comment with a count of the comments so far.
Conflict resolution is a no-op since the user is likely the only one
updating his/her doc at any given time. It's trivial then to have a
view sorted by #comments as the key and you can get the top-10 that


On Mon, Oct 5, 2009 at 9:04 PM, Andrew Melo <> wrote:
> you can emit the number of comments as your key, then it will be
> sorted and you can take the top 10 or whatever.
> HTH,
> Andrew
> --
> Andrew Melo
> On Mon, Oct 5, 2009 at 8:36 PM, Seggy Umboh <> wrote:
>> Hello everyone,
>> I've been reading about couchdb and just started playing around with it, and
>> I am wondering, in the typical blog/comment example application, is it
>> possible to get a list of the Top 10 commenters? It is trivial to write a
>> view to get the number of comments for each commenter, but now I want to
>> sort the result of that view by the values....

View raw message