Let’s say You add a published boolean field, This would have to be set in all records, or did I miss something?
kokolegorille
wolfiton
I am sorry I think my way of expressing it was not proper what I meant is that 2 opinions you both offered have some advantages and differences.
@OvermindDL1 use the idea of languges code in each table, that speeds up the database look up.
@kokolegorille, your idea is to bring one table will act as an observer to decide which languge is needed to be displayed and your solution doesn’t repeat the langauges codes in all the tables.
I also respect both of your opinions and your experiences.
I hope that I didin’t offend any of you.
0
OvermindDL1
Oh absolutely not! You want to publish each individually. You could easily have, say, an english one published and still be working on a german one to be published later when you finish it. ^.^;
0
kokolegorille
Ok, the published example is too simplist.
Let’s say You have a lot of metadata (position, counter cache etc.), unrelated to translation content 
0
OvermindDL1
Then normalize the data as per standard SQL, move that identical part out. ^.^
Shouldn’t position/counter’s etc… be language specific too though? It’s trivial to aggregate them in sql but it’s impossible to peal them apart if needed (like to see language specific stats).
1
kokolegorille
Oh, position is to set a specific order, not to be calculated.
It’s again a Ruby example, from acts_as_list gem.
I also use lft and rgt fields quite often for nested set… and this data should not be duplicated. I use this hierarchy when dealing with Page and SubPage (and SubSubPage).
0
OvermindDL1
kokolegorille
What would You do if You want to set an arbitrary order?
I used Ruby/Rails before, that is why I often compare both.
Joe Celko’s SQL for smarties, how to represent a tree in a database.
0
OvermindDL1
I’ve always used the published-date for that. My usual published field (like at work) isn’t a boolean, it’s a nullable datetime field. If null then it’s invisible and that won’t change. Once published then it sets to ‘now’ so it’s visible and ordered with other datetimes in relation to that. Or I can set it in the future and it will be visible at that point. As translations are finished you can set them to all the same date if you want, but it might be useful to set a translation at a later date (like at the time it was finished) if you so wish so it gets ordered at the top of a language-specific ‘new’ page.
I mostly come from web frameworks in C++, erlang, and I hate to admit it but PHP (it was paid work so eh…), never touched ruby to date. ^.^;
Heh, never heard of such a thing. Do you have a link of descriptions? I’m curious if there are ideas I can swipe. ^.^
0
kokolegorille
I had a request for a product’s catalog, where user should be able to choose in which order products would be displayed.
also
0