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 nrstott@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;
        b=doHLLzgpm2IOUjoTL826w8VviIW2XQGv6X7c2NbMJz2zybS5f08fnL0dQ7nr7cp4a2
         zyN8OLIcfGgTWkW8ohyvm4i/zzfshSVNjGavUk1/aMZvpApvuSFTttAFMVYEbhthfGvA
         lT/DlDxTIRg4qRyVUeHShgkal8medR+ENwBHs=
MIME-Version: 1.0
In-Reply-To: <31696010-2186-4BCD-9A59-218EAA60844F@devonweller.com>
References: <3E00739B-2973-4A13-AF4D-9992A39A6527@devonweller.com>
	 <ea28b75b0911050604p20dcd1f2ldf28dc61a719d96c@mail.gmail.com>
	 <254CF962-CC02-4FEA-9A60-ECF2E71CA2D2@devonweller.com>
	 <B9B4BFDF-EA7A-4D1D-B156-FD6ED652B38E@googlemail.com>
	 <ea28b75b0911051018j509b06d7l5351a9aff3e0001b@mail.gmail.com>
	 <EEB28BC6-1890-4641-94A6-AA4AC824F408@googlemail.com>
	 <ea28b75b0911051053i463dcc31j65441259e9326154@mail.gmail.com>
	 <31696010-2186-4BCD-9A59-218EAA60844F@devonweller.com>
Date: Thu, 5 Nov 2009 13:57:39 -0600
Message-ID: <ea28b75b0911051157g294b6e42ue4b8bcfa892777b6@mail.gmail.com>
Subject: Re: Sorting items by number of votes
From: Nathan Stott <nrstott@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=0015175cd86eb6b9de0477a523b2

--0015175cd86eb6b9de0477a523b2
Content-Type: text/plain; charset=ISO-8859-1

If you put your votes in array belonging to the resource document, you will
run into problems with conflicts if voting occurs near simultaneously on the
same resource.

On Thu, Nov 5, 2009 at 1:51 PM, Devon Weller <dweller@devonweller.com>wrote:

>
> Thanks Nathan, Daniel and others.  Those are some good suggestions and
> workarounds.
>
> I think I may need to rethink my design and just put the votes in an array
> belonging to the resource document.
>
>
> As for the aggregate sum example in the wiki, I still think it might be
> broken.  I'm starting another thread with details about that in a separate
> email.
>
> - Devon
>
>
>
> On Nov 5, 2009, at 12:53 PM, Nathan Stott wrote:
>
>  Right now I'm using lists to do 'joins' of my multi-doc-type views.
>>
>
> On Nov 5, 2009, at 11:43 AM, Daniel Truemper wrote:
>
>  You could however write another type of document (VoteCount) into your
>> database containing the resource and the number of votes. Then emitting as
>> key something like [ #votes, resource ] will give you an ordered view based
>> on the number of votes. You could trigger the view update from the client
>> each time a vote is made (i.e. add a vote document, call the view, update
>> the VoteCount document and call the new view to get the ordered votes). You
>> could also do this automatically on the CouchDB using update notifiers and
>> simple Bash/Python/Perl/whatever scripts...
>>
>

--0015175cd86eb6b9de0477a523b2--