zlacker

>… 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.

>>0cf861+(OP)
Not to be outdone: https://thedailywtf.com/articles/what_is_truth_0x3f_

>>0cf861+(OP)
"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.

>>orthox+c5
Must have been super fast though

>>datadr+ne
Not just fast, it's web-scale

https://www.youtube.com/watch?v=b2F-DItXtZs