News for hackers. Stuff that matters.

A comment on What ORMs Have Taught Me: Just Learn SQL (2014). Parent comment

Re:What ORMs Have Taught Me: Just Learn SQL (2014) by giantDinosaur on Wednesday October 21, 2020 @05:26AM (#24846122)
wait, what? doesn't support joins? Things like this make me doubt my fundamentals. 'Are joins really necessary?' is the question now running through my mind ;-)
[ Parent | on HN ]
Re:What ORMs Have Taught Me: Just Learn SQL (2014) by Dave3of5 on Wednesday October 21, 2020 @05:48AM (#24846209)
It does not support joins. The expectation is that you "Preload" your data which is a fancy way of saying load it all into memory. The performance of this is trash so don't use that ORM there are a few better ORMs for GO mentioned in the issue.

Yes joins are really necessary in SQL they are a foundational part of using any relational database.

[ Parent | on HN ]
Re:What ORMs Have Taught Me: Just Learn SQL (2014) by giantDinosaur on Wednesday October 21, 2020 @06:24AM (#24846387)
Yes, they're literally the second thing one learns about SQL, really. I'm not being too serious about rethinking whether they're necessary, to be clear!

What a strange design decision though. I don't really understand why it is doing this? Why would anyone really think it's a good idea?

[ Parent | on HN ]
Re:What ORMs Have Taught Me: Just Learn SQL (2014) by Dave3of5 on Wednesday October 21, 2020 @07:00AM (#24846565)
> I'm not being too serious about rethinking whether they're necessary, to be clear!

My apologies if I came off condescending, it's hard to impart tone of voice in text.

> I don't really understand why it is doing this?

I think it's because it makes the SQL Generation harder. I think the lib at the moment is simply a search and replace on a bunch of SQL strings.

[ Parent | on HN ]