Learn More
Resend Email
37
Your biggest personal challenges as a dev?
Week 94 Group Rant
seraphimsystems
7y

When the email address is the primary key and the customer "doesn't have an email address"

Like, they're free and it's 2018... Why not?

rant

wk94
Favorite
Ranter
Comments
  • 10
    7y
    You messed up pretty bad this time. Better not use email as primary key.
  • 7
    7y
    @Aitkotw yeah, it's a bad practice. emails can change, user can have more than one email etc etc. Many reasons not to. Use int or guid
  • 11
    7y
    @Aitkotw @Kekica not my design, I saw the flaw on day one

    "So how do I change the email address?"

    "Err, well you can't, that's the primary key"

    "Haha... Oh wait you're serious... Shit..."
  • 1
    7y
    People can have reasons which other people won't understand :)
  • 2
    7y
    @linuxxx maybe or maybe not
  • 3
    7y
    @Aitkotw Uhm that's more like a fact haha
  • 2
    7y
    Can you send us the vectorial of the logo please?
    Sure, give me your fax number
  • 2
    7y
    They probably do have email addresses but don’t want to give them to some data whore company.
  • 1
    7y
    @SSDD true, even when they are told that it means they can get no confirmations, notifications or receipts and we don't share our data ever.

    We don't even use it to market for ourselves haha, seperate opt in list.
  • 3
    7y
    Why would you use email as primary key, it's really bad practice...
  • 1
    7y
    When a company asks me for an email address, I use a spam address. Maybe he doesn't have one and doesn't want to get spammed.
  • 0
    7y
    Who the fuck uses a email address as a primary key?! That's a very VERY bad idea.
  • 1
    7y
    Why is your primary key not an integer?
    Fail.
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment