Hacker News new | ask | show | jobs
by AdieuToLogic 3380 days ago

  Probably worth having a autoincrementing ID
  on tables using uuids as well, though.
Quite true, IMHO. I usually define both an auto-incrementing integral primary key (PK) as well as a unique string column for the URN. The PK is used for deletes/updates/joins/referential integrity and is never exposed beyond the server processes.