I'm about to re-implement localizations.
I have a table with some properties (for example fruits categories, countries, cities etc) and for each type of property there is a localization table.
I need to select localizations for given language and if not defined, then select default language.
I use for this two views in database. It cross joins with languages and assigns labels and the second one joins first view on self to use default language label where missing.
And these views are also joined to other tables where I need those data.
And it's of course slow.
So I've been searching for other ways how to solve it.
I got idea about selecting all properties into application and then select data without these localizations and after that merge it.
(Like preload localization and then use it)
What's best way how to do localizations?
I don't want to do localizations in languge per column style, cuz if you want to add new language, you have to alter table and that's not good approach I guess.