News for hackers. Stuff that matters.
Re:Excel and SQL by kijin on Friday May 24, 2013 @01:12AM (#5761367)
> ticker text, position integer, purchase_price real

Oops, bad example. Never store money using a floating-point data type! SQLite has a NUMERIC type that preserves the exact value of your decimal amount.

There are no comments on this comment yet.