Any good resources, guides, approaches or tips to building custom modules with multi-lingual data? I don't mean localizing static text, but dynamic content. For instance, say I have a table called tblProducts with this data:
I would want to store localized versions of the title and description. I could have up to 10 languages, so I want to design this smartly. My initial thought is to break out the title & description fields into a separate translation table with the ID and the local as keys.
When querying, I would always pass in the locale, join the tables etc etc.
Is this the general approach that most others use? It makes sense in my head, but if there are other examples or some DNN API stuff I should take advantage of, please comment.