#1
  1. A Change of Season
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,167
    Rep Power
    220

    How come HUGE systems like ontraport allow multiple records with same email address?


    I had several arguments with Ontraport people.

    They allow muitiple records in the database have the same email address!

    Why do they do that?

    I remember reading Rudy's book years ago I am pretty sure most things I learned there don't agree with this design.

    TO me it seems really phucked up since email address is unique.

    What's your thoughts on that?

    Thanks
  2. #2
  3. Lazy Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,280
    Rep Power
    9645
    Apparently they decided that an email address is not enough information to uniquely define an identity in their application.

    Not all email addresses correspond to a single person. Like "admin@example.com". There's surely someone watching that account, but over time that person will change and the email address will not. Even credit card numbers have been reused over time - you'd probably think those are unique too.

    What do you want to hear? "Oh, yeah, that's horrible!" No, not necessarily. "No, you're the dumb one!" Sure, I'll say that, but it isn't the point here.
  4. #3
  5. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,701
    Rep Power
    4288
    Originally Posted by English Breakfast Tea
    ... since email address is unique.
    no it isn't
    Code:
    person                  email
    ---------------------   ------------------
    English Breakfast Tea   forums@devshed.com
    requinix                forums@devshed.com
    r937                    forums@devshed.com
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  6. #4
  7. A Change of Season
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,167
    Rep Power
    220
    Originally Posted by r937
    no it isn't
    Code:
    person                  email
    ---------------------   ------------------
    English Breakfast Tea   forums@devshed.com
    requinix                forums@devshed.com
    r937                    forums@devshed.com
    Uncle Rudy is here yayyyy

    Do you ever check that address to see if someone has contacted you Rudy (forums@devshed.com)?

    Apparently, email addresses have other usages than communication

    Thanks
  8. #5
  9. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,701
    Rep Power
    4288
    Originally Posted by English Breakfast Tea
    Do you ever check that address to see if someone has contacted you Rudy (forums@devshed.com)?
    i made that up to illustrate a point ;o)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo