4 ms·
>… 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 th
by 0cf8612b2e1e 2y 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.
- DaiPlusPlus 2y agoNot to be outdone: https://thedailywtf.com/articles/what_is_truth_0x3f_ https://thedailywtf.com/articles/what_is_truth_0x3f_
- orthoxerox 2y ago"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.
- datadrivenangel 2y agoMust have been super fast though
- DaiPlusPlus 2y agoNot just fast, it's web-scale https://www.youtube.com/watch?v=b2F-DItXtZs https://www.youtube.com/watch?v=b2F-DItXtZs