Assure that the Userd.email is unique. about lifeinvader HOT 3 CLOSED

http://www.postgresql.org/docs/8.1/static/ddl-constraints.html <- in short you can specify a column to be unique as a constraint during table creation, shouldn't have to worry about this in the implementation if done correctly.

from lifeinvader.

We will need to check to make sure that the email that someone registers is not already in the database. That way we can provide the user with an error when they try to register with an already registered email address. We also need to preform this check when a user edits their settings page.

Whether or not we try to insert the row into the database, and then catch the error (im not sure if we will be able to distinguish between different errors here), or check before we insert the data, we still need to implement the error handling.

from lifeinvader.

ah good point, jumped the gun on this one 👍

from lifeinvader.