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: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=wOX3Q3FdR/s+Dn5o8W//NCDx0MILSPUcSukipYETSnovYRpkGRm9knpJm09N4GkYd9gNmqhKA/vin4MhtwG+9I+9QBWcEOi7E7a5SYwxz2Fvwu+3oD1Z8hbHfcxRyI/+tBAo12p617eDIHrStAY4cWhc4O2imWrkUb5C30JhGR8=;
Message-ID: <177224.67898.qm@web50304.mail.re2.yahoo.com>
References: <536177.27209.qm@web50301.mail.re2.yahoo.com>
 <AANLkTimWLe-fKmYAj4_TD6R6bwEIm-I19GHs9C04VE8R@mail.gmail.com>
Date: Mon, 5 Jul 2010 21:40:46 -0700 (PDT)
From: Alex Yiu <alexyiu@yahoo.com>
Subject: Re: "_attachements" field name in CouchDB
To: user@couchdb.apache.org
In-Reply-To: <AANLkTimWLe-fKmYAj4_TD6R6bwEIm-I19GHs9C04VE8R@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-858166309-1278391246=:67898"

--0-858166309-1278391246=:67898
Content-Type: text/plain; charset=us-ascii


Hi, 

Option #1: really defeats the purpose of having nested JSON objects
Option #3: Base64 encoding is not that efficient. Bloated ratio around 1.3x. 

I would consider option #2: if CouchDB has no intention to support this feature, that is I will manually maintain the cross reference relationship between the line and attachments. e.g. :

[ { "line" : 1, "price": "33.4", "picture" : { "attachmentName" : "picX" } , { "line": 2, ...  } ]
"_attachments" : {
  "picX" : ...,
  ... 
}

Similar to "id" and "ref" concepts. 

I would consider my proposal in my original email is a nice to have feature. 


Alex


________________________________
From: Anh <7zark7@gmail.com>
To: user@couchdb.apache.org
Sent: Mon, July 5, 2010 9:14:04 PM
Subject: Re: "_attachements" field name in CouchDB

Could you consider any of these 3 options?:

1) A document per line item, and a single standard attachment name
such as "picture"?

2) A convention for attachments associated with a series of line items
in a single doc, such that _attachments contains a corresponding
series of attachments?  E.g.:

[ { "line" : 1, "price": "33.4" } , { "line": 2 } ]
"_attachments" : {
   "picture1" : ...,
   "picture2" : ...,
}

3) Base64 the image into the "picture attachement" as text, and you
handle the unencoding, etc.


Hope this helps.

On Mon, Jul 5, 2010 at 8:36 PM, Alex Yiu <alexyiu@yahoo.com> wrote:
>
>
> Hi, all,
>
> I am a newbie to CouchDB. Sorry for a potential newbie question.
>
> I am wondering whether we can associate binary attachment to a field name defined by users, instead of the generic pre-defined "_attachments" field name? If we can do that, we can manage association between multiple attachments and different parts of the JSON document easier.
>
> For example, if a JSON doc represents a purchase order, a PO can have multiple line items. Each line item may have optional attachment.
>
> [ { "line" : 1, "price": "33.4", "picture attachement" : { ... } } , { "line": 2, ... } ]
>
> Within the "picture attachement" object, it contains some special fields to denote it is an attachement.
> e.g.  "picture attachement" : { "_attachment_id": "..." , ... }
>
> We can do something to that extent already. That is great.
>
> If not, do we have a JIRA issue for that already?
> If we have not that JIRA issue yet, does it worth log an issue there now?
>
>
> Thank you so much for answering this newbie question!!!
>
>
> Alex Yiu
>
>
>
>


--0-858166309-1278391246=:67898--