Re:SQLite 3.32
by cordite on Saturday May 23, 2020 @11:52AM
(#23283926)
As in like Java Bigdecimal, with a BigInteger on the left side, and a fixed precision on the right?
[ Parent
| on HN ]
Re:SQLite 3.32
by fauigerzigerk on Saturday May 23, 2020 @12:01PM
(#23284000)
As in other database systems such as Postgres. Even a C# style decimal floating point type would be sufficient.
Basically--it's a struct containing a byte array, weight, scale, and sign, and all the arithmetic operations are implemented in software. So it's really slow, and each RDBMS has to implement this type from scratch, or find a vendor lib that provides a suitable one, because C/C++ standard libraries don't provide one.