News for hackers. Stuff that matters.
Re:'My life was ruined by a typo' by joering2 on Tuesday March 21, 2017 @08:36PM (#13927614)
Might be as simple as some genius designed database using usernames instead of ids for relations in tables.

Trust me - I seen things like this before (with huge companies where dev soft costed millions of USD). Probably same story here.

Re:'My life was ruined by a typo' by mjevans on Wednesday March 22, 2017 @01:17AM (#13928635)
Or worse, someone designed the database correctly, but then added a (hidden to the user) unique identifier that's normalized in some way to make it short, unique, and limited on allowed characters.

Often /that/ doesn't get updated when they update the username, leading to mass confusing since external tooling will use that as the subject identifier instead of actually being given a proper internal identifier. (Offhand I can't recall if any particular standard happens to require that such an identifier start with a letter; at least one probably does.)

Re:'My life was ruined by a typo' by chris_wot on Wednesday March 22, 2017 @06:38AM (#13929837)
And this is why you should always use synthetic keys.