[Dbix-class] Advices needed on creating multilingual application

[Jonas Alves]

On 23/09/2007, Matt S Trout <dbix-class at trout.me.uk> wrote:
>
> On Fri, Sep 21, 2007 at 07:19:52AM +0300, mbit at ukr.net wrote:
> > Matt S Trout(dbix-class at trout.me.uk)@Wed, Sep 19, 2007 at 06:14:08PM
> +0100:
> > > 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 :)
> >
> > Didn't get your humor here ;-)
> >
> > But please answer a question: can we somehow create relationship where
> we can
> > provide args in runtime, so this is possible:
>
> Yes.
>
> But like I say, that's not the approach I'd use since you'll bottleneck
> horribly on the DB that way.
>
> Generate out to .po files and stop worrying about abusing SQL.


Yes, that's good for the text on the templates or for the form validation
errors.
But if you have a lot of articles inserted with a CMS that is not the way to
go.

-- =

Jonas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20070923/08e=
4ce4b/attachment.htm