News for hackers. Stuff that matters.
Re:Why you should probably be using SQLite by nly on Friday October 27, 2023 @01:17PM (#38041192)
Using a fixed point representation doesn't solve your SUM() problem.

If you add 0.1 to 1000000 with an integer representation scaled by 10^6 then you are still boned.

Binary floats may actually produce a better result here.

What you really want is a decimal floating point type with a suitable amount of significant digit precision.

Re:Why you should probably be using SQLite by cdelsolar on Friday October 27, 2023 @02:35PM (#38042178)
int64?