vendredi 30 mars 2018

Multi Language Approach - Advice Needed

I'm creating a portal where i have users, questions (just like laracasts), articles and businesses

Now im creating this in more than 40+ languages so im planning to store the translations in the database. For example i have created articles and article_translations table and storing each article in multiple language in the article translations table. Now i have to do the same for users, questions and businesses.

So i created profiles table where i have a type field(user, business) and fields as per the user choice are displayed on the form. All fields are nulled. The problem is a user will have a profile in 40+ languages which means each user will have 40+ entries for his profile(english, spanish, italian and so on).

This works fine for me and im able to translate the whole website. However, im confused if this is the right approach as if in future the site gets big and has huge users the database would be more huge.

Any experts in here who could suggest me if i can go with this approach or will this be a problem for me in the future.

Note: This approach has given me ability to translate the whole site to preferred language.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire