SQLite does not have built-in UUID functions, but by getting creative with the randomblob(N) function we can generate version 4 (random) UUIDs. Before we continue, it's important to note that you should verify whether SQLite's random functions are adequate for your usecase. They may not return truly random data. However, as the RFC notes, "they (UUIDs) MUST NOT be used as security capabilities". And since we all follow that to the letter, it doesn't really matter.. right? The excellent SQLite...
No comments yet. Log in to discuss on the Fediverse