[Dbix-class] Advices needed on creating multilingual application

[Matt S Trout]

On Wed, Sep 19, 2007 at 11:50:26AM +0300, mbit at ukr.net wrote:
> Hello.
> 
> I need an advice on writing multilangual web-application. Question is not
> about i18n or localization, that's was described here many times and i got it
> worked pretty easy :) The thing is in organizing database storage.
> 
> Let's assume an easy application. We have a blog. But there are three versions
> int three languages: en, de and ru for example. But when we don't have a
> translation for the en part, we show original part. This way first we add
> original post in de, and then if we translate that part we add translation. And
> when a user views en version of the site he sees translated part. Otherwize he
> sees de version. This way in all three languages we have complete website, just
> not everything is always translated, but we know what changed and was added in
> all languages.

Don't hit the database for every string.

Use Catalyst::Plugin::I18N and generate out to string dictionaries / .po files.

Then you can make the DB storage as inefficient as you like :)

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/