On 15 Nov 2016, at 12:59pm, Cecil Westerhof <cldwester...@gmail.com> wrote:
>> SQLite has a randomblob function which can be used to select part of the >> UUID, but you need to pick a UUID scheme suitable for your purposes to know >> how much of it can be random. > > That is something to look into. Lots of people use UUIDs of this form: <https://en.wikipedia.org/wiki/Universally_unique_identifier#Version_4_.28random.29> Pick your own value for 'y'. And even pick your own value for some of the substrings, though some considerations of randomness and probability start to figure in if you do that. Frankly I'd generate my random hex digits in my preferred programming language rather than have SQLite do it, but it does seem possible to have SQLite do it using randomblob(). Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
