News for hackers. Stuff that matters.
Re:Why SQLite succeeded as a database (2016) by patrickthebold on Wednesday February 19, 2020 @08:50PM (#22372092)
How do you handle things like multiplying by some interest rate of 3.125 or (1 + 0.03125)^-354 as examples.

Sure you can round at the end but then you have to worry about compounding errors.

Re:Why SQLite succeeded as a database (2016) by anoonmoose on Wednesday February 19, 2020 @09:03PM (#22372144)
I think that's just part of the process of deciding how small an increment each integer represents (dollars, cents, centi-cents, milli-cents).
Re:Why SQLite succeeded as a database (2016) by elcritch on Thursday February 20, 2020 @03:51AM (#22373689)
Accounting rules often care more about consistency than precision per se. As long as the code follows accepted accounting rules (say bankers rounding) choosing a known precision works. Often GAAP and other standards don’t define all details for, say amortization, but if you use a scheme the code should always use that method.