data-integrity – Tarik Billa

File containing its own checksum

April 5, 2023 by Tarik

I created a piece of code in C, then ran bruteforce for less than 2 minutes and got this wonder: The CRC32 of this string is 4A1C449B Note the must be no characters (end of line, etc) after the sentence. You can check it here: http://www.crc-online.com.ar/index.php?d=The+CRC32+of+this+string+is+4A1C449B&en=Calcular+CRC32 This one is also fun: I killed 56e9dee4 cows … Read more

What’s wrong with foreign keys?

October 3, 2022 by Tarik

Reasons to use Foreign Keys: you won’t get Orphaned Rows you can get nice “on delete cascade” behavior, automatically cleaning up tables knowing about the relationships between tables in the database helps the Optimizer plan your queries for most efficient execution, since it is able to get better estimates on join cardinality. FKs give a … Read more