That was my first thought too when I read the WSJ article, but who knows what shenanigans sw engineers can get themselves into

Sure, but..... 

DELETE records where username is NULL ;

is not the same as:

DELETE records where username is 'NULL';

SQL treats the first one as true null, but it treats the second as the string 'NULL'.

Or am I taking crazy pills today???

fiatbad

can confirm. Thought I was being clever/early by reserving the 

 username for a no-kyc custodial account. Account disappeared one day (with my sats). Emailed the devs but they couldn't find any record of the account ever existing.

 and my acct got wiped. This is why its also important to log CHANGES to the database in a separate table or logging system. Or keep robust backups of the DB. That way if someone makes a mistake, you can at least investigate and resolve any missing data.

tech

When your last name is Null, nothing works

SimpleStacker

can confirm. Thought I was being clever/early by reserving the `null` username for a no-kyc custodial account. Account disappeared one day (with my sats). Emailed the devs but they couldn't find any record of the account ever existing.

Someone probably ran a `DELETE records where username is NULL` and my acct got wiped. This is why its also important to log CHANGES to the database in a separate table or logging system. Or keep robust backups of the DB. That way if someone makes a mistake, you can at least investigate and resolve any missing data.