Should I use a number or email id to identify the user on the website?

Question

I have a web application in which I register users based on their email id.

In terms of design / usability / flexibility, should I assign a unique number to each user or identify the user based on email?

The advantage of assigning a unique number:

• I can change the login itself at a later point without losing user data (flexibly).

Inconvenience:

• I have to deal with numbers when using sql command line (with error).

What's better? Do you see any other problems that need to be considered for any circuit?

Answer 1

The identity of your users must be unique and unchanged. Choosing an email address as an individual is not a good idea for several reasons:

• Email is one aspect of user identification that can change at any given time.
• You may decide to allow multiple emails.
• You can decide to add other faces, such as OpenID or Live ID, or even just a regular username.
• There is nothing wrong with letting multiple personal communities share the same aspect of email. This is a rare scenario, but not unheard of.
• , . ( ? ? -?)

, . , 13 . .

Answer 2

. , , . , sql.

Answer 3

- ! .

. , , .

Answer 4

. sql , - .

, , , .., .

URL-, , , , URL-.

, , .

Answer 5

, , . , -.

, - , , , .

sql , , -, , .

Answer 6

.

• ?
• , ( , , m.mouse disney.com
• , , , ,
• ,

Answer 7

. , , , . , , ..