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