[sqlite] AUTOINC vs. UUIDs

On 21/05/2015 09:33, J Decker wrote: > chance of collision is slim... it's a truly large amount of bits... > There's libuuid for linux, and builtin functions for windows to create them. The chance of collision is only slim if you (as some people have already indicated) have a proper entropy

[sqlite] AUTOINC vs. UUIDs

Just to chime in here: I think using UUIDs for primary keys is an absolutely terrible idea, instead. First off, how are you going to generate them? How will you avoid collisions? Why should it be necessary to using that much storage space for a primary key and what's the reason for not using