Internationalization > 150 languages

System Information
  • Strapi Version: 4.1.8
  • Operating System: Windows
  • Database: MySQL 5.7
  • Node Version: 16.4.2
  • NPM Version: 7.18.1

We are at this moment looking for an headless CMS that can handle content for site/app with more then 150 languages. We are testing now with Strapi incl. MySQL. We have all the content in CSV files. So we thought we make an big start by importing the content directly into the DB. Now we found the following:

Example: You have English and French; You translate one Collection entry. In the DB (collection_localizations_links) you get:

collection_id | inv_collection_id
1 | 2
2 | 1

So for 1 content item you get 2 rows. Now we add 1 language (with an translation; Dutch); you get:

collection_id | inv_collection_id
1 | 2
2 | 1
1 | 3
3 | 1
2 | 3
3 | 2

What you get for one content entry is:

English is connected to French
French is connected to English
English is connected to Dutch
Dutch is connected to English
French is connected to Dutch
Dutch is connected to French

The biggest issue here is that its exponentional growing. When we add 1 other language (Deutsch) you get:

collection_id | inv_collection_id
1 | 2
2 | 1
1 | 3
3 | 1
2 | 3
3 | 2
1 | 4
4 | 1
2 | 4
4 | 2
3 | 4
4 | 3

For 1 content item with 150 languages you get 22.350 rows in the Database (150x149).

The biggest issues is that every language needs to be connected to all the other languages. So its hard to create all the connections and import them directly into DB.

Question: Isn’t there a solution to only connect the translation to the default language?

Thanks