pull down to refresh

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.
40 sats \ 1 reply \ @fiatbad 20 Feb
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???
reply
That was my first thought too when I read the WSJ article, but who knows what shenanigans sw engineers can get themselves into
reply