Advantages and disadvantages of GUID / UUID database keys
Advantages: Can generate them offline. Makes replication trivial (as opposed to int’s, which makes it REALLY hard) ORM’s usually like them Unique across applications. So We can use the PK’s from our CMS (guid) in our app (also guid) and know we are NEVER going to get a clash. Disadvantages: Larger space use, but space … Read more