News for hackers. Stuff that matters.
Re:Appropriate Uses for SQLite by fauigerzigerk on Monday February 12, 2018 @10:59AM (#16359461)
Can you explain to me what particular cases postgresql's decimal type cannot handle properly _and_ conveniently?
Re:Appropriate Uses for SQLite by anarazel on Monday February 12, 2018 @11:27AM (#16359677)
> Can you explain to me what particular cases postgresql's decimal type cannot handle properly _and_ conveniently?

I entirely agree that numeric is a good solution for this case.

But to try to answer your question nevertheless: I'd say there is potential for storage density and math performance issues. You really need to have a number of numerics for each row, and a lot of rows to make storage density matter. If you do a lot of aggregates over numerics you definitely can notice the CPU overhead of them over say a plain float. But most of the time that doesn't matter.

Re:Appropriate Uses for SQLite by fauigerzigerk on Monday February 12, 2018 @11:37AM (#16359754)
I agree completely.