openerp-expert-framework team mailing list archive
-
openerp-expert-framework team
-
Mailing list archive
-
Message #00418
Re: float errors propagating to 10^-2 in OpenERP v5...
On Monday 16 August 2010, Raphaël Valyi wrote:
> Hello,
>
> we while ago we debated here the usage of Floats vs Decimals in Python.
>...
When talking money, decimals (+ numeric, in SQL) are supposed to yield better
precision at calculations, than floats[1].
However, I feel that this is not our problem. IMHO the error is not at the
choice of arithmetic /storage/, but at the interface of data to and from the
db.
Every time we fetch sth from the db, or store something in it, we may lose a
little bit of information, here, some decimal digits. We spend resources to do
that, too.
So, my counter-proposal is that we let the database do more, instead of
writting those loops in Python (or Java, or Python over Java, or Java over
Ruby over Python over Java etc.). Let SQL do what it is good at: Sums.
I do appreciate that some developers are allergic at SQL and would write
anything else instead. But here, Python with its metaprogramming would allow
us to write some intelligent framework to abstract over some complex SQL query
building. Let us try to go to that direction[2].
This means it will definitely be a post-v6.0 thing.
[1] which, may even be a myth, because floats /do/ have the necessary precision
to always round up to the correct value.
[2] see line 37 at:
http://git.hellug.gr/?p=xrg/a2blib;a=blob;f=a2blib/Form/Class.SumMultiView.inc.php;h=4a0d9b562958c8739a2735c
--
Say NO to spam and viruses. Stop using Microsoft Windows!
Follow ups
References