Linux Journal: Using MySQL for Exchange Rate Updates
Jun 09, 2004, 08:30 (2 Talkback[s])
(Other stories by James Hatridge)
"I am an American living in Germany, and I export German stamps
to English-speaking markets, mainly to the US, UK and Australia.
Once a quarter, I mail the new stamps to my customers with a
statement priced in their local currency. This means that I have to
keep track of the exchange rates for the Euro, US dollar, UK pound
and Australian dollar.
"Many years ago, when I started my stamp business, I solved this
problem by listening to the radio every day at 6pm, when the daily
US dollar fix was issued. I wrote the exchange rate on some scrap
paper. It was a mess to keep all these little notes together. The
rates for the Australian dollar and the British pound I had to
guess when I made my quarterly price list. Today, by using the
Internet, MySQL, PHP, KMail, and SuSE 8.2 Linux, all the tracking
and conversions are done automatically..."