Use email address as primary key?

by

String comparison is slower than int comparison. However, this does not matter if you simply retrieve a user from the database using the e-mail address. It does matter if you have complex queries with multiple joins.

If you store information about users in multiple tables, the foreign keys to the users table will be the e-mail address. That means that you store the e-mail address multiple times.

More Related Contents:

  1. How to implement a many-to-many relationship in PostgreSQL?
  2. Temporal database design, with a twist (live vs draft rows)
  3. How to check if a table exists in a given schema
  4. How to update selected rows with values from a CSV file in Postgres?
  5. How to create multiple one to one’s
  6. Strings as Primary Keys in SQL Database [closed]
  7. Transpose latest rows per user to columns
  8. Custom SERIAL / autoincrement per group of values
  9. Safely rename tables using serial primary key columns
  10. A beginner’s guide to SQL database design [closed]
  11. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  12. single fixed table with multiple columns vs flexible abstract tables
  13. Primary key or Unique index?
  14. How can I send email from PostgreSQL trigger?
  15. How to design a database for User Defined Fields?
  16. SQL Between clause with strings columns
  17. Insert an image in postgresql database
  18. Composite Primary key vs additional “ID” column?
  19. Database EAV Pros/Cons and Alternatives
  20. How to find a table having a specific column in postgresql
  21. INSERT COMMAND :: ERROR: column “value” does not exist
  22. MySQL – how to front pad zip code with “0”?
  23. Bulk/batch update/upsert in PostgreSQL
  24. Postgres Error: More than one row returned by a subquery used as an expression
  25. Grant privileges for a particular database in PostgreSQL
  26. SQL: Using NULL values vs. default values
  27. Upsert with a transaction
  28. How to compare dates in datetime fields in Postgresql?
  29. Relational Data Model for Double-Entry Accounting
  30. Single or multiple databases

Leave a Comment