title: How to choose between UUIDs, autoincrement/sequence keys and sequence tables for database primary keys?
body: <p>I'm looking at the pros and cons of these three primary methods of coming up with primary keys for database rows.</p>
  
  <p>So assuming I am using a database that supports more than one of these methods, is there a simple heuristic to determine what the best option would be for me? </p>
  
  <p>How do considerations such a distributed/multiple masters, performance requirements, ORM use, security and testing have on the choice? </p>
  
  <p>Any unexpected drawbacks that one might run into?</p>