News for hackers. Stuff that matters.
Re:Instead of deleting account, NYT appends ‘1000’ to userna... by unicornfinder on Tuesday April 28, 2020 @10:04AM (#23007058)
That and why not allow null for the foreign key constraint and set it to nullify upon deletion? Or indeed, anonymise data.
Re:Instead of deleting account, NYT appends ‘1000’ to userna... by sopooneo on Tuesday April 28, 2020 @11:54AM (#23008224)
I have used that pattern in my apps and found it works well. But then I've watched video from respected DB experts, that I learn a great deal from, where they practically beg you to stop using nullable columns.

So I'm torn, because I think there may just be a major problem I've not yet grown my apps big enough to suffer. Anyone have thoughts either way?

Re:Instead of deleting account, NYT appends ‘1000’ to userna... by dmux on Tuesday April 28, 2020 @04:49PM (#23011802)
Any particular videos you'd recommend?