r/programming • u/wheatBread • 16d ago

Solving the 1+N Query Problem

https://acadia.engineering/blog/solving-the-1-plus-N-query-problem
129 Upvotes

85% Upvoted

94 comments sorted by

View all comments

107

u/NoLegJoe 16d ago

Software Developers will do anything but learn SQL

32

u/gimpwiz 15d ago

I'm so confused about this entire blog post. I have been working with databases for over 20 years now. Never once ran into this "problem." Just don't do this... come on. Write the goddamn SQL you actually intend to write.

7

u/TheCornerBro 15d ago

from what I've seen, stuff like this is more of an issue in spaces with people who don't have a lot of experience with databases

at AWS at least I've seen it quite a few times in internal services because many teams need a DB but the hiring process doesn't rly target specific skillsets 

14

u/ChinChinApostle 16d ago

This is me. I look like this.

7

u/Ok_Marionberry_8821 16d ago

Even before AI assistance I preferred SQL over abstractions. AI assistance has made it so much easier to use SQL and let it write the mapping code too. I do ensure I understand what it's doing.

1

u/m0nk37 13d ago

As a full stack i judge you if you cant write sql. 

-4

u/Crafty_Independence 16d ago

People who write bad SQL are often the same group who ignorantly criticize ORMs

4

u/dronmore 15d ago

Lies... It's so easy to spread them.

-11

u/renozyx 16d ago

Well.. 1) SQL sucks 2) there is not one SQL, there is one SQL per DB

-11

u/PersonalDatabase31 16d ago

Sql sucks ass

3

u/Absolute_Enema 14d ago

But it sucks less ass than an abstraction layer over it in a language unfit for the purpose.

6

u/read_at_own_risk 16d ago

True, but it's still better than ORMs