2 ms·
> You still can't store a float in the database and get it back out unmodified. SQLite will expand it to a double, When would a double not be an acceptable rep
by dotancohen 5y ago
> You still can't store a float in the database and get it back out unmodified. SQLite will expand it to a double,
When would a double not be an acceptable replacement for float? Seriously interested. If the application layer works with floats, then a double-precision float should contain all possible values. I'd really love to hear about the use-case, I'm sure they exist even if I can't think of one.
> and it can't store NaNs.
Well, neither can other small-time databases such as MySQL. Postgres does, though, which I did not know until googling it now.
- mastax 5y agoStoring 13,000,000 floats to disk per minute on user machines. Doubling storage usage for no reason is not okay, we're already having problems filling up disks with other data.
- dotancohen 5y agoStorage concern, I see. Yes, that actually was the only thing I could think off. Thank you.