Databases
StackOverflow2013
Postsdbo
PODatabase localization (multilingual) design for Python/Django
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatabase localization (multilingual) design for Python/Django
    primarykey
    data
    text
    <p>I am currently in the process of creating an app, on which the information will be accessed by people who speak different languages. The information will be highly unique, so using translation tools will not be good enough. All the information will need to be in different languages, and when the user logs in, the information is displayed according to his settings. Now, the application is based off Django and MySQL. I see that Django has a localization feature, but I don't quite understand it. Is it calling a translation mechanism or something? I don't get it.</p> <p>Putting that aside, I was wondering what was the best approach to solve this issue. The number of different languages is unknown for now. So I don't think storing the exact translation of each column within <strong>one table</strong> is a good idea, even though it would save time when querying. (no inner joins etc).</p> <p>1) Should I look into the Django localization feature? What is it exactly? [I don't really want to store the translations into files.]</p> <p>2) What Database design is best for multilingual applications? I found those ones:</p> <ul> <li><a href="http://www.codeproject.com/Articles/8084/Creating-multilingual-websites-Part-2" rel="nofollow noreferrer">http://www.codeproject.com/Articles/8084/Creating-multilingual-websites-Part-2</a></li> <li>Storing the translation of each information in the same table, with _language appended in the different columns.</li> <li><a href="https://stackoverflow.com/questions/316780/schema-for-a-multilanguage-database">Schema for a multilanguage database</a></li> </ul> <p>How people usually solve this issue? Thanks a lot!</p> <p>EDIT: I am not looking especially for something that is THAT easy to use. Mostly for something that is performant and won't create a giant mess in my DB... is that possible?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USabisson
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODatabase localization (multilingual) design for Python/Django
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave you seen [django-hvad](https://github.com/KristianOellegaard/django-hvad)?
      singulars
      1. PODatabase localization (multilingual) design for Python/Django
      1. USilvar
    2. COI am not looking especially for something that is THAT easy to use. Mostly for something that is performant and won't create a giant mess in my DB... is that possible?
      singulars
      1. PODatabase localization (multilingual) design for Python/Django
      1. USabisson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload