in reply to [OT] Database Design

I prefer to keep the number of involved databases down, so I would introduce a db scheme where you've got multiple entries for one post, only differentiated by a second field holding the language.

id:1 - lang:en - "post content in en"
id:1 - lang:fr - "post content in fr"
ect.

Replies are listed 'Best First'.
Re^2: [OT] Database Design
by Anonymous Monk on Aug 11, 2010 at 03:01 UTC

    I thought about this too ... but it will be difficult to add new languages and if you have too many fields the table will look messy.

    I want to make it as dynamic as possible ... that's why I am trying to find a solution that works but I am not expert in db design

[reply]

In Section Seekers of Perl Wisdom