News for hackers. Stuff that matters.

A comment on Ask HN: How do I represent a hierarchy in RDBMS?. Parent comment

Re:Ask HN: How do I represent a hierarchy in RDBMS? by m33k44 on Wednesday May 29, 2019 @02:33AM (#20037343)
What are the pros and cons of this approach?
[ Parent | on HN ]
Re:Ask HN: How do I represent a hierarchy in RDBMS? by dragonwriter on Wednesday May 29, 2019 @05:38PM (#20045814)
The pros are you aren't creating unnecessary sequences and tables, which has both storage space and join complexity savings.

The cons are...none, really; the extra surrogate keys aren't buying you anything.

[ Parent | on HN ]