What is the best way to store content in multiple languages (translations) ? The same question about the prices in multiple currencies ?
The problem: ############ World Wide Book Shop (collection of books from multiple countries in multiple currencies and languages) Model: ###### Book Question: ######### Every book has it's own original title and multiple translations. How do I store in the DB translations? Question: ######### Every book has it's own price in currency of the production country. How do I store prices with their currencies? *Note: I cannot unify prices into one currency, because currency rate does change and therefore price. I need to store currency in original form , and then (when searching/filtering, or daily) unify it to one currency so I can easily order by price. Example: Book1: original price = 10 USD Book2: original price = 10 EUR Now order from the cheapest : Book1, Book2, Now filter where price>=11 USD : Book2 *Note: the number of currencies and languages is not specified and is likely to change (the solution should be flexible) -------------------------------------------------------------------------------------------------- My suggested solution about "Prices and Currencies" is: to have 3 columns in table: original_price original_currency unified_price This way, I would update unified_price daily according to currency rate and I gain ability to order and filter by price by bringing search criteria to unified currency. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---