News for hackers. Stuff that matters.
Re:Creative usernames and Spotify account hijacking by timv on Tuesday June 18, 2013 @11:43PM (#5903638)
I'm not sure how they can avoid storing both.

They need to store the verbatim username in order to know how to display the username in the UI.

They need to store the canonical username in order to efficiently know whether a given canonical username is in use.

Re:Creative usernames and Spotify account hijacking by brokenparser on Wednesday June 19, 2013 @02:46AM (#5904049)
Not necessarily, in PostgreSQL you could simply add a canonicalised index.
Re:Creative usernames and Spotify account hijacking by timv on Wednesday June 19, 2013 @03:15AM (#5904132)
Well, in that case you're still storing it, you're just letting the the db store it for you.

But - when the issue here is the question of the reliability of the implementation of the canonicalisation function, having it done once in python, and then again by PG is going to be a huge issue.