Interesting that you had issues with floating point precision, what type were you using inside your application? SQLite's floating point type (REAL) is 64 bit.