On 23/09/2007, Matt S Trout <[EMAIL PROTECTED]> wrote: > > On Fri, Sep 21, 2007 at 07:19:52AM +0300, [EMAIL PROTECTED] wrote: > > Matt S Trout([EMAIL PROTECTED])@Wed, Sep 19, 2007 at 06:14:08PM > +0100: > > > On Wed, Sep 19, 2007 at 11:50:26AM +0300, [EMAIL PROTECTED] 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
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
