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).
[ Parent
| on HN ]
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.