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 jchris@gmail.com designates
 209.85.212.193 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=Mw7J9gfxbUaOC+pbhsJpff8b7ly3RWc4c/8JvN7QXXnjA0VNye2tkX1huT5UpHZ5Wu
         vYMqkMu9L2iqIkyJl/EvYC8ngQuUe3P0hDREtwobj6bAUTZpy7kkQYM733igdP+9tF2U
         jzSD8fDWG045AKOn5K4vtIaZHGIjznYNFlN/8=
MIME-Version: 1.0
Sender: jchris@gmail.com
In-Reply-To: <ddd139590908060621g346a3f2cx8f9494ef5602196c@mail.gmail.com>
References: <ddd139590908060621g346a3f2cx8f9494ef5602196c@mail.gmail.com>
Date: Thu, 6 Aug 2009 08:53:35 -0700
Message-ID: <e282921e0908060853w489f0dep3403187243bba5c9@mail.gmail.com>
Subject: Re: sorted documents by their position
From: Chris Anderson <jchris@apache.org>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Thu, Aug 6, 2009 at 6:21 AM, didier
lafforgue<didier.lafforgue@gmail.com> wrote:
> hi all,
>
> I'm having fun time with couchdb but I'm stuck with a simple problem:
> documents sorted by their position. Actually, I've documents called proje=
cts
> described like this:
>
> {
> =A0_id: "first_project",
> =A0 name: "my first project",
> =A0 description: "lorem ipsum ...",
> =A0 type: "project"
> }
>
>
> {
> =A0_id: "second_project",
> =A0 name: "my second project",
> =A0 description: "lorem ipsum ...",
> =A0 type: "project"
> }
>
> And I'd like to sort them using a drag&drop ui. So, I thought about addin=
g a
> new field (named position) and then updating their position field once I
> dragged one of them. You get the picture.
> Unfortunately, partial updates do not seem to exist in couchdb and I do n=
ot
> like the fact to save ALL my documents to update their positions, especia=
lly
> when I have hundred or thousand of projects.

If you store the position as a float (or a string) then you only have
to update the position on the changed document, not all of the docs in
the list.

Eg, if you want project P to come between projects B and C, then
average the positions of B and C and make that the new position of P.

> I came with an idea: denormalize the position field and create a document
> storing the positions (just an array field with project ids) so that I do
> not have to update all my documents but just the positions document. My o=
nly
> concern is that I'm unable to sort my projects with a couchdb view (I've =
to
> do it in the server side which is dirty).
>
> Is there a clean way to solve my problem ?
> Thanks guys !
>
> =A0Didier
>


--=20
Chris Anderson
http://jchrisa.net
http://couch.io