News for hackers. Stuff that matters.

A comment on Why SQLite succeeded as a database (2016). Parent comment

Re:Why SQLite succeeded as a database (2016) by gen220 on Wednesday February 19, 2020 @07:12PM (#22371569)
+1 adding my anecdata to this.

If you don’t need irrational numbers (few financial applications do?), the tuple of (value, scale) can take you very far.

[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by utxaa on Thursday February 20, 2020 @09:48AM (#22375408)
you never really deal with irrationals ... do you mean floating point?
[ Parent | on HN ]
Re:Why SQLite succeeded as a database (2016) by gen220 on Friday February 21, 2020 @10:44AM (#22383909)
Nope, specifically meant irrationals.

Floating point (up to a certain amount of absurdity) you can describe with integers (value, scale).

Real numbers you can describe with integers (numerator, denominator, scale).

Irrationals are more difficult. That's why we try not to use them :). Hopefully your company's commission tiers are not defined in terms of circles or euclidean distances.

[ Parent | on HN ]