News for hackers. Stuff that matters.

A comment on Many small queries are efficient in SQLite. Parent comment

Re:Many small queries are efficient in SQLite by mvc on Tuesday February 16, 2021 @10:03AM (#26154460)
> Most of the time we need to store monetary values with two decimal places (cents).

Yeah who cares about fractions of pennies anyway. Just makes things complicated.

[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by magicalhippo on Tuesday February 16, 2021 @10:25AM (#26154705)
Yeah for being so uptight about just about everything, the officials seems quite relaxed about values slipping between the cracks due to lack of decimal places.

Like, total invoice value can only be specified with two decimal digits, typically in foreign currency. Yet we also have to specify per-line value in local currency, also with only two digits. And then the per-line values are used to calculate taxes and whatnot...

[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by jrochkind1 on Tuesday February 16, 2021 @12:45PM (#26156545)
The US IRS (tax agency) allows you to round nearly all values to dollars ignoring cents altogether.
[ Parent | on HN ]