What are the approaches to internationalizing data in a database and which one is correct?

Question

PostgreSQL

There was a question about the internationalization of articles and other data that, according to the selected locale, should be displayed in the desired language.
How to display text in different languages ​​in templates and notifications is understandable, but what about the data in the database? How to organize this business?

Answer 1

Usually I added a locale field to the collections, you specify the language in which it is displayed for each entry, because for example, not every news in Russian will have an Arabic translation, and a translator is usually not always at hand

Answer 2

Excellent gem https://github.com/globalize/globalize
Used in the project, no complaints