How to store product prices in a database?

Question

Database

Hello, there is an online store. For example, two currencies - the dollar and the euro. One of the currencies is current, that is, the one in which all prices on the site. For example, the database contains all prices in dollars and you need to change the current currency to euro. It is unlikely that the prices in the database should be recalculated every time the current currency changes? How is the price of goods usually stored? I assume that the prices are in the default currency, and when changing the currency to another, the price displayed in the view is converted to another currency according to the current exchange rate?
Thank you.

Answer 1

For good, to avoid unnecessary mistakes, store one base price.
And a table with the current exchange rate.
And at request to recalculate.
--
Otherwise, let's say you have 5 currencies. And a lot of goods.
You change the price tag, at the time of the price change something goes wrong and kirdyk, you get an unrelated base where prices do not randomly correspond to each other.