Switch content by language?

Question

Django

How to implement switching for example publications, with. language change?
For example, if the language of the site is Russian - all publications are in Russian, if English, then in the same way!
Should it be 2 databases or 2 columns of content?

Answer 1

anyway, anyway.

Answer 2

Two databases are more difficult to maintain in the same state, and such a solution generally looks strange, plus an extra overhead in the form of two processes of the databases themselves. The variant with two columns looks more correct and more logical. It is also possible that the columns depending on the language are generally placed in a separate table, plus there is a column with the language code / identifier and foreign key for entry in the main table. This approach will slightly increase the complexity of database queries, but in the future it will make it easier to add more languages.