Geek Answers Handbook

Multilingual Database Design Template

I am currently working on Blog-Software, which is supposed to offer content support in several languages.

I am thinking of a way to design my database (MySQL). My first thought was as follows:

  • Each record is saved in a table (allows you to name it entries). This table contains information that does not change (for example, a unique identifier, if published or not, and a post-type).
  • Another table (let it be called content) contains rows (for example, content, title, date and author of a specific language).
  • Then a unique record identifier is attached to them.

The idea is that one article can be translated into several other languages, but this is not necessary. If there is no translation in the user's native language (determined by his IP address or something else), he sees the standard language (which will be English).

For me, this sounds like a simple multilingual database, and I'm sure there is a design template for this. Unfortunately, I have not found.

If there is no template, how would you understand that? Any input is welcome.

+5
source share
3 answers

- , . , (Entry), Content.

+6

( ) . db, imho - , .

+1

With a little text and a simple application this will work. In general, you may be bitten by additional joins, especially if your database is larger than a ram. Presenting things in the correct order (sorting) may also require a solution.

0
source

More articles:


All Articles