Lars Wirzenius on Nostr: I agree that "natural keys" in database, or other data structures, are often not a ...
I agree that "natural keys" in database, or other data structures, are
often not a good idea. You can arrange for a unique ID your application
chooses to never change. I've seen the following change, in my career:
* Unix username
* Unix uid, without changing username
* SSN
* passport number
* email address
* company registration number
* several companies with the same registration number
* street address, without recipient moving
https://blog.ploeh.dk/2024/06/03/youll-regret-using-natural-keys/
often not a good idea. You can arrange for a unique ID your application
chooses to never change. I've seen the following change, in my career:
* Unix username
* Unix uid, without changing username
* SSN
* passport number
* email address
* company registration number
* several companies with the same registration number
* street address, without recipient moving
https://blog.ploeh.dk/2024/06/03/youll-regret-using-natural-keys/