I don't understand, can you not just use blobs as primary keys? $ sqlite3 SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table t(id blob primary key); sqlite> insert into t values(randomblob(8)); sqlite> insert into t values(randomblob(8)); sqlite> insert into t values(randomblob(8)); sqlite> insert into t values(randomblob(8)); sqlite> select hex(id) from t; 1499C74FAF191054 2DDC29C2D6C72CD8 6BFD11FD9A446A56 99B86AA30E484BCB sqlite> explain query plan select * from t where id=randomblob(8); QUERY PLAN `--SEARCH TABLE t USING COVERING INDEX sqlite_autoindex_t_1 (id=?) sqlite> select hex(id) from t where id < randomblob(8); 1499C74FAF191054 2DDC29C2D6C72CD8 6BFD11FD9A446A56
On Thu, Aug 23, 2018 at 12:30 AM D Burgess <dburges...@gmail.com> wrote: > To answer Jens - electronic IDs. > > And yes I use bignums on the client side. > > Note that I have workarounds and the system I have is stable and > works, I just rue not having 64 bits and UNSIGNED indexes. > There was additional work to get it all going in SQLite. I probably > would not have originally chosen SQLite if I had known what I know > now. > > The reason for the original question was that a friend in a different > industry asked me the same question. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users