News for hackers. Stuff that matters.
Re:Appropriate Uses for SQLite by icebraining on Monday February 12, 2018 @10:07AM (#16359020)
Arbitrary-precision numbers. DBs like Postgres support them, as do most languages (e.g. Ruby has BigDecimal, Python has Decimal).
Re:Appropriate Uses for SQLite by aeorgnoieang on Monday February 12, 2018 @10:34AM (#16359231)
Neither `BigDecimal` in Ruby or `Decimal` in Python are quite what I'd expect for "arbitrary-precision".

From the docs for [`BigDecimal`](http://ruby-doc.org/stdlib-1.9.3/libdoc/bigdecimal/rdoc/BigD...):

> Ruby provides built-in support for arbitrary precision integer arithmetic. For example: > > 4213 -> 1265437718438866624512 > > BigDecimal provides similar support for very large or very accurate floating point numbers.

My takeaway from the above is that, if arbitrary precision is needed, you should still just use integers. Tho, in practice, it may not be significant.

Re:Appropriate Uses for SQLite by fauigerzigerk on Monday February 12, 2018 @11:34AM (#16359735)
Integers are not magic. If you want arbitrary precision on top of integers you're going to need arbitrarily long integers as well.
Re:Appropriate Uses for SQLite by aeorgnoieang on Monday February 12, 2018 @02:32PM (#16361300)
I was referring to Ruby and based on the first sentence I quoted:

> Ruby provides built-in support for arbitrary precision integer arithmetic.

[I'm also assuming that it's really arbitrary precision and not just 'really big but limited' precision.]