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