[orm-devel] How to handle multi language?

Diedrich Vorberg diedrich at tux4web.de
Sat Jun 18 11:20:35 CEST 2005

Hi Werner!

> All your suggestions got me thinking.  Whenever you or anyone else  
> has a moment to look at the attached, I would be greatful for  
> comments/critics - this is nothing urgent.
> Any hints, comments, critic (but be nice, please!) is very welcome
Thank you very much for sharing your ideas with the list!

I'd like to make two remarks, though:

1. I don't think it is a good idea to have several rows per language  
in the same table. This is going to make SELECT queries less streight  
forward, because you always have to exclude those entries you don't  
want for the current language. (If the parent table is the only one  
you do SELECTs on that's not a problem, of course). Anyway, I'd like  
to have one row per country, though dispite the face that there are  
three country names, it's only one country.

2. Just a small one: I think lang_2oneColumn can be optimized by  
using a JOIN so you don't need to run two queries.

Have a nice weekend!

Diedrich Vorberg <diedrich at tux4web.de>      .---.   /             \
http://tux4web.de Tel: 02302 425269        /     \ ((__-^^-,-^^-__))
                                            \.O-O./  `-_---' `---_-'
"Unix is simple, but it takes a genius     /`\_/`\   `--|o` 'o|--'
to understand the simplicity."            //  _  \\     \  `  /
                       - Dennis Ritchie   | \     )|_     ): :(
                                         /`\_`>  <_/ \    :o_o:
      Associate Member of the FSF #1245  \__/'---'\__/     "-"

More information about the orm-devel mailing list