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 kxepal@gmail.com designates
 209.85.216.180 as permitted sender)
Received-SPF: pass (google.com: domain of kxepal@gmail.com designates
 10.229.102.148 as permitted sender) client-ip=10.229.102.148;
MIME-Version: 1.0
Date: Fri, 24 Feb 2012 09:04:48 +0300
Message-ID: 
 <CAHdjip+rsQO_S4PsiwADOAe6SxmKdVv47Ugn_mNgitek0q54Og@mail.gmail.com>
Subject: Localize documents data
From: Alexander Shorin <kxepal@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi!

While English language is quite common wide the rest real world is not
so perfect(: I'd like to talk about how to store multi language data
within single document (or may in different ones?). How would you
solve this task, when you need to keep information in English, French,
Czech and other languages for document values and keys?
I've found next ways to solve this problem:

1. by using gettext on CouchDB side. po2json looks promise[1]

2. by storing locale information within separate document field (lets
call it `.locale`) that contains json-patches[2] grouped by locale id.
Example structure:
{
  ".locale": {
    "fr_FR": [...],
    "ru_RU": [...]
  }
}
When you need to return translated document to specific locale, you
just apply set of patches to document.

3. by storing translation within target fields. Example:
{
  "beast": {
    "en_US": {
      "key": "beast",
      "value": "monkey"
    },
    "ru_RU": {
      "key": "=D0=B7=D0=B2=D0=B5=D1=80=D1=8C",
      "value": "=D0=BE=D0=B1=D0=B5=D0=B7=D1=8C=D1=8F=D0=BD=D0=B0"
    },
    "es_ES": {
      "key": "bestia",
      "value": "mono"
    }
  }
}

4. just store additional document per language: disk space is cheap
(ok, not so as one year ago) and do not create more problems for your
head!(:

Currently, my opinion lies between p.1 and p.2, but what's the right
option, the best practice to be able translate document data for
various languages?

Thanks.

[1] http://jsgettext.berlios.de/
[2] http://http://tools.ietf.org/html/draft-pbryan-json-patch

--
,,,^..^,,,