Comment by 0cf8612b2e1e
1 year ago
>… People had to use `char(1)` columns with CHECK constraints to store '0'/'1' - or worse: 'T'/'F' or 'Y'/'N'
If you are truly blessed you get to see all of these in a single database. Also “Yes”/“No” with that specific casing.
Not to be outdone: https://thedailywtf.com/articles/what_is_truth_0x3f_
"Check constraints make the database run slower, just don't generate any values other than YN in the application layer"
You can guess how many foreign keys that database had.
Must have been super fast though
Not just fast, it's web-scale
https://www.youtube.com/watch?v=b2F-DItXtZs