> On Aug 23, 2018, at 4:22 AM, Wout Mertens <[email protected]> wrote: > > I don't understand, can you not just use blobs as primary keys?
You can. And while the usual bignum encodings won't sort correctly with the default blob collation, you can get around that with clever encoding. For example, for unsigned bignums you just start with a byte containing the byte-count, followed by the bignum bytes in big-endian order. Signed bignums are a little trickier, but not much (left as an exercise for the reader…) —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
