Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: