4 ms·
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 st
by timv 13y ago
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.
- brokenparser 13y agoNot necessarily, in PostgreSQL you could simply add a canonicalised index.
- timv 13y agoWell, 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.