Thought some of you might enjoy seeing this article. I make no comment on what
I think of the reasoning therein. It’s set in the PostgreSQL world, but you
could make an external function for SQLite which generates UUIDs.
"Today, I'll talk about why we stopped using serial integers for our primary
keys, and why we're now extensively using Universally Unique IDs (or UUIDs)
sqlite-users mailing list