[ILUG-BOM] How to design multilingual website

Kenneth Gonsalves lawgon@[EMAIL-PROTECTED]
Tue Sep 19 12:14:17 IST 2006

On 19-Sep-06, at 11:44 AM, Philip Tellis wrote:

>> yes. One is the strings used in the code - just make a  
>> standard .po file and you are done. Translating the content - all  
>> my content is stored in database tables. I create fresh tables for  
>> each language - the headache is to get people to translate, so  
>> this has not been implemented as yet
> do you do run time string replacement or do you maintain separate  
> copies of html files for each language?  the former is non- 
> performant, the latter is a maintenance nightmare unless you have a  
> single source of truth that's compiled to each language version

string replacement is handled by python's gettext module so it is  
runtime replacement from the compiled .mo file. All content is pulled  
from the database, so, for example, I have a table like this:

create table article(
id    serial  primary key,
title varchar(100)
matter text

then the language tables:

create table langarticle(
id serial primary key,
art_id foreignkey to article(id)
lang_id foreigngkey to languages(id)
title - varchar(100)
matter - text

and depending on the language setting, the appropriate file is pulled  
out of the database and sent to the template


Kenneth Gonsalves
Associate, NRC-FOSS
lawgon at au-kbc.org

More information about the Linuxers mailing list