News for hackers. Stuff that matters.
Re:Why SQLite succeeded as a database (2016) by massysett on Wednesday February 19, 2020 @08:13PM (#22371893)
In addition to the other workarounds suggested, you can store the numbers in two columns - one for the coefficient and one for the power of ten, negated. For instance 2.50 becomes 250 and 2, meaning 250 x 10 ^ -2. You can then do math at the application level, or even in SQLite with user-defined functions or even with recursive CTEs if you’re a bit of a masochist.

There are no comments on this comment yet.