Re: [sqlite] storing unsigned 64 bit values

2018-09-27 Thread Nathan Wagner
On Thu, Sep 27, 2018 at 11:05:24AM -0600, Keith Medcalf wrote: > so the only way to store something [larger than a signed 64-bit int] > is as a double-precision float. I'd like to point out that you could *store* it as the hex or decimal text representation of the integer. If you included

[sqlite] dbhash collision

2018-09-25 Thread Nathan Wagner
I am working up code to calculate a hash over parts of the data in an sqlite database, and as a start looked at the dbhash.c code found at https://www.sqlite.org/src/artifact?ci=trunk=tool/dbhash.c I don't think the code as is works correctly, it is easy to construct a hash collision between two