5 ms·
I once ran a query on a live production web site thinking I was doing a SELECT but somehow ran an UPDATE which set all the millions of users' gender to 'M', reg
by kingcharles 5y ago
I once ran a query on a live production web site thinking I was doing a SELECT but somehow ran an UPDATE which set all the millions of users' gender to 'M', regardless of their selection.
Restoring from backups would have been a nightmare. And telling my supervisor would have been a nightmare.
So I used everyone's selected title (Mr, Ms, Mrs etc) to reset their gender setting, and then put the keyboard down and went to bed.
- scollet 5y agoI think you made the wrong call here.
- inquist 5y agoOn the plus side, why are they storing gender info in the first place?
- kingcharles 5y agoBecause zero thought went into the account signup form. It just asked for whatever the coder who wrote it thought it needed. Shit, it might even have been me who wrote the signup. I don't remember. This was back in 1999. Now I try to ask for the absolute bare minimum of information to onboard someone. No information at all if I can! Times have changed. Damn, I don't even identify as a binary gender myself anymore and hate forms that ask me.
- jaywalk 5y agoWhy would you jump to the assumption that they don't need to store gender?
- easrng 5y agoBecause there are very few situations where storing gender is nesecary.
- lostlogin 5y agoHaving worked in a healthcare setting and having had a patient come through who had undergone gender reassignment surgery, it turns out to be easier get the surgery than to get their gender and name changed in the healthcare database. I said I’d help them get it fixed, but I couldn’t get this done.
- totony 5y agoWhy? Looks good to me
- drewzero1 5y agoRight, it may be a clever fix but it's not safe to assume a user's gender based on their name or honorific.
- jfrunyon 5y agoI'm not sure that you understand what the distinction between "Mr" and "Mrs" is.
- zarzavat 5y agoWhat did you do about 'Dr's?
- kingcharles 5y agoI can't remember if the system had Dr. as an option. Probably not, IIRC.
- jayzalowitz 5y agoDoctors arent people, they are student loan debt... not neccesary.
- bellyfullofbac 5y agoI wonder if the few Dr's could be fixed manually by checking their names, e.g. if they're Steven or Maria, the gender should be clear enough. At least that was the case when I was young, but don't tell anyone I said this, the rage machine might knock on my door.