Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of alexander.uvarov@gmail.com
 designates 209.85.218.221 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=content-type:mime-version:subject:from:in-reply-to:date
         :content-transfer-encoding:message-id:references:to:x-mailer;
        b=jyYYW2uPQMEN/DDr6MQJlO8k24blKuKkspehJB4N4osipIuNhA6PcB5pg2x17/4Gwo
         K9Zs41cQ1k/it3ANUIk7jfq1ZD8BLeh2XO7/5VAz4oyCkXUa+4AWYA0LNzv5NaUlJlul
         YN+ayyfT/NZHb89Tj4vSfXiqpDnYNbeViMo3k=
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1078)
Subject: Re: an aggregate object
From: Alexander Uvarov <alexander.uvarov@gmail.com>
In-Reply-To: <s2qa4761ad41004121359g73b209c6qa6004b369d2d2766@mail.gmail.com>
Date: Tue, 13 Apr 2010 03:14:58 +0600
Content-Transfer-Encoding: quoted-printable
Message-Id: <649AAA20-9486-48DE-8AE0-1865DBD44F39@gmail.com>
References: <s2qa4761ad41004121359g73b209c6qa6004b369d2d2766@mail.gmail.com>
To: user@couchdb.apache.org

Why not just create the following:

{
    "_id": "some_id_3",
    "type": "Page",
    "text": "Some text",
    "related_docs": ["some_id_2, "some_id_3"]
}

{
    "_id": "some_id_2",
    "type": "Image",
    "size": "1024x768",
    "title": "Nice chick"
}

{
    "_id": "some_id_3",
    "type": "Movie",
    "duration": "600",
    "title": "Cool movie"
}

And store actual image and movie as attachment.

Use this guide =
http://blog.couch.io/post/446015664/whats-new-in-apache-couchdb-0-11-part-=
two-views to retrieve Content and related documents in 1 query.

On 13.04.2010, at 2:59, Kenneth Tyler wrote:

> this may sound a little strange
>=20
> i am trying to build up a "content" object that can contain several
> kinds of files.
>=20
> for example, it might contain a some text, and an image, and a video =
clip
>=20
> i want to tag my documents in couch so that i can retrieve the whole
> "family" of documents
>=20
> so i use a field called "name" and i put the uuid generated for the
> first document in the family into that field in all the documents i
> want to belong to the content "family".... i add that documents own
> uuid as the second part of the "name": 89ehjwol8e7/7896w89e6r
>=20
> i this case we would have documents T I AND V, and they would all have
> "names" with the same uuid at the beginning of the string
>=20
> so i can make a view with the "name" fields as the key and get back
> all three documents by using a regular expression that looks for the
> common head of the string in all the name fields
>=20
> .....
> it gets more complicated later... but first i wanted to check and see
> if this approach "fits" with the way couchdb "wants" things to be done
>=20
> i love couch... i really think its going to be huge.... i'm coming
> from a ms access application developer background... so a lot of stuff
> is strange at first... and i have a lot of "relational" habits about
> how i think about data
>=20
> thanks
>=20
> ken tyler