We Can Do Better Than SQL (2019)

Re:We Can Do Better Than SQL (2019) by goto11 on Sunday August 09, 2020 @06:01AM (#24098496)

Oh yeah, that is a "natural join". Problematic since it depends on the names of the columns. I can see how it is convenient though. I would like something like this, just based on declared foreign key relationships rather than column names.

[ Parent | on HN ]

Re:We Can Do Better Than SQL (2019) by doublesCs on Sunday August 09, 2020 @08:17AM (#24099100)

I could say the same thing about your suggestion: Problematic since it depends on what you set as primary/foreign key. I can see how it is convenient though.

[ Parent | on HN ]

Re:We Can Do Better Than SQL (2019) by goto11 on Monday August 10, 2020 @05:44AM (#24107336)

What is problematic about that? Column names are just names, there is no guarantee that value in one table corresponds to a value in another table just because the columns have same name. Private/foreign key declarations enforces consistency so it is not possible to have an orphan foreign key.

[ Parent | on HN ]

Re:We Can Do Better Than SQL (2019) by nsonha on Sunday August 09, 2020 @11:25AM (#24100169)

Foreign key is a formal semantic while same column name is just a convention

[ Parent | on HN ]