HI oren, There was recent similar discussion about design for content translations and the answer I gave there may be useful to you:
http://osdir.com/ml/RubyonRailsTalk/2010-04/msg02235.html I'm currently adding content translation to the Kete open source Rails app (http://github.com/kete/kete and http://kete.net.nz). You may find some example code there useful. A lot of people, including myself with http://github.com/kete/mongo_translatable, are starting to use a NoSQL backend for translation. The latest I18n gem just added Tokyo Cabinet support, too. Hope this helps, Walter On Sun, May 2, 2010 at 4:40 PM, oren <[email protected]> wrote: > I am building a Web service that will provide content for different > client via Rest API. > > currently I have: content has_many :keys (since many keys can > reference the same content) > content table has only one field - text > keys table has name and content_id > > example for key: help_about > example for content: "This website is for blablabla.." > > I want to add support for translations. > is it reasonable to store the content in separate table for each > language? > for example - content_english, content_spanish, etc. > If it is, how will rails handle it? currently Content.find 1 will > return the text of contents table. > and I will need to tell rails to grab it from content_english or > content_spanish. > > btw, I looked at a gettext example and it uses only one table with > locale field to determine what language to show. but I am not sure > it's a good solution for massive chunk of content and many languages. > > > Thanks! > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
