Comment on It's ~2026 –. ChatGPT still doesn't allow email changeComments−oytis9moYour email is your identity. If they allow you to change your email, what they should refer you by, your passport number? Was kind of easier in the times of usernames, but these are long gone−wizzwizz49moThey should use the integer primary key of the users table, of course.−piskov9moNah, that’s too 1985.Because client doesn’t know it, inserts can be slow in cross-db environment.Guid is always better (can be client generated), and modern guid versions can be ordered chronologically−TZubiri9moThat's probably an implementation feature that is hidden and not dependable if it exists at all.−oytis9moPlease enter your integer primary key and password to log in.−esafak9moYou can use a random numerical ID as PK and let people associate as many authn IDs as they want after logging in with one.−Reubachi9moWho in this scenario outlines the key infrastructure, and how is the private key maintained?−esafak9moprimary key. https://en.wikipedia.org/wiki/Primary_key−thiht9moWhy would you allow this complexity for basically nothing?−esafak9moUsing a separate table for authn is a basic pattern for this problem. What would you do?−lxgr9moMost services I know allow changing both.
Comments
Your email is your identity. If they allow you to change your email, what they should refer you by, your passport number? Was kind of easier in the times of usernames, but these are long gone
They should use the integer primary key of the users table, of course.
Nah, that’s too 1985.
Because client doesn’t know it, inserts can be slow in cross-db environment.
Guid is always better (can be client generated), and modern guid versions can be ordered chronologically
That's probably an implementation feature that is hidden and not dependable if it exists at all.
Please enter your integer primary key and password to log in.
You can use a random numerical ID as PK and let people associate as many authn IDs as they want after logging in with one.
Who in this scenario outlines the key infrastructure, and how is the private key maintained?
primary key. https://en.wikipedia.org/wiki/Primary_key
Why would you allow this complexity for basically nothing?
Using a separate table for authn is a basic pattern for this problem. What would you do?
Most services I know allow changing both.