News for hackers. Stuff that matters.
Re:Appropriate Uses for SQLite by BareNakedCoder on Tuesday February 13, 2018 @01:20PM (#16369376)
Strings don't work well with numeric aggregate SQL functions like SUM or MAX. Also, won't work well with comparisons or sorting: "111.00" is less than "9.99" string-wise (unless you store all numerics with a bunch of leading "0"; but then that takes a lot more space).

There are no comments on this comment yet.