News for hackers. Stuff that matters.
Re:Appropriate Uses for SQLite by dragonwriter on Monday February 12, 2018 @11:56AM (#16359908)
Serious monetary work often needs values smaller than cents. Exact decimals or, better, exact fractions are often what you want.
Re:Appropriate Uses for SQLite by lsaferite on Monday February 12, 2018 @03:21PM (#16361694)
What is the typical use-case of a unit smaller than the smallest tradable currency unit? Mind you, I understand there are smaller units than the circulated currency (For the USD you have a mill which is 1/10 of a cent).
Re:Appropriate Uses for SQLite by tracker1 on Tuesday February 13, 2018 @04:23AM (#16365810)
Bitcoin currency trades? Large fractions. Convert to/from yuan/yen, large whole numbers, back to US, somewhere in the middle.

Tracking transactional values for large stock and currency trades would be an example. That said, could use integers to represent arbitrary precision.