News for hackers. Stuff that matters.

A comment on Cost of a Join. Parent comment

Re:Cost of a Join by dragonwriter on Tuesday August 14, 2018 @07:15PM (#17762717)
> It allows you to do more relational things later if you want to attach things to a date like an is_holiday or a was_raining column.

While I get that calendar tables are fun and all, if you have a date type you can just add a “holidays” table for that if you need it later, without a table of all dates.

[ Parent | on HN ]
Re:Cost of a Join by jaggederest on Tuesday August 14, 2018 @07:43PM (#17762826)
Precisely. This is exactly why decomposing things into relations is important. The naive approach is to "keep all the things and all their details in one big table", and that's what causes so many problems.
[ Parent | on HN ]