How to deal with rounding errors of floating types for financial calculations in Python SQLite? [duplicate]

Question

I'm creating a financial app and it seems my floats in sqlite are floating around. Sometimes a 4.0 will be a 4.000009, and a 6.0 will be a 6.00006, things like that. How can I make these more exact and not affect my financial calculations?

Values are coming from Python if that matters. Not sure which area the messed up numbers are coming from.

Answer 1

Please use Decimal

http://docs.python.org/library/decimal.html