Conversation

Notices

1. Embed this notice
   Ulysses (professionalbigot69@poa.st)'s status on Saturday, 17-May-2025 02:54:30 JST Ulysses
   never use a user's email address as a unique id in a database entry
   • Embed this notice
     d (deprecated_ii@poa.st)'s status on Saturday, 17-May-2025 02:54:29 JST d

     in reply to

     • John_Darksoul
     @John_Darksoul @professionalbigot69 most people designing database schemas seem to have no idea what they're doing
     
     I wouldn't say using an email address as a primary key is technically wrong, especially if the organization is issuing the addresses and people can't just change them, but it's definitely not a very good idea
     Johnny Peligro likes this.
   • Embed this notice
     John_Darksoul (john_darksoul@poa.st)'s status on Saturday, 17-May-2025 02:54:30 JST John_Darksoul

     in reply to
     @professionalbigot69 Just auto generate an employee id for every entry. Who doesn’t do that?