r/programming • u/wheatBread • 7d ago

Solving the 1+N Query Problem

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

85% Upvoted

94 comments sorted by

View all comments

106

u/NoLegJoe 7d ago

Software Developers will do anything but learn SQL

30

u/gimpwiz 7d 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 6d 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 

13

u/ChinChinApostle 7d ago

This is me. I look like this.

6

u/Ok_Marionberry_8821 7d 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 5d ago

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

-5

u/Crafty_Independence 7d ago

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

2

u/dronmore 7d ago

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

-12

u/renozyx 7d ago

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

-11

u/PersonalDatabase31 7d ago

Sql sucks ass

4

u/Absolute_Enema 6d ago

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

5

u/read_at_own_risk 7d ago

True, but it's still better than ORMs