Re:Ask HN: Should a login be a Username or an Email?
by majewsky on Sunday July 02, 2017 @07:32AM
(#14682044)
> you obviously dont want to display the database table id
Why not? A lot of services assign a user ID (literally a number) or contract ID, which I can read to the customer service rep on the phone so they can quickly find my account without having to go through the trouble of mistyping my given name (see username) at least once.
Another advantage of usernames is to mask the email address specially if you run public forums etc. Also, this allows changing email address without losing identity on front end as you obviously dont want to display the database table id.