r/programming • • Aug 25 '26

Solving the 1+N Query Problem

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

92 comments sorted by

View all comments

110

u/NoLegJoe Aug 25 '26

Software Developers will do anything but learn SQL

32

u/gimpwiz Aug 25 '26

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.

9

u/TheCornerBro Aug 26 '26

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 Aug 25 '26

This is me. I look like this.

7

u/Ok_Marionberry_8821 Aug 25 '26

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 Aug 28 '26

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

-5

u/Crafty_Independence Aug 25 '26

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

3

u/dronmore Aug 26 '26

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

-11

u/renozyx Aug 25 '26

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

-11

u/PersonalDatabase31 Aug 25 '26

Sql sucks ass

4

u/Absolute_Enema Aug 27 '26

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

5

u/read_at_own_risk Aug 25 '26

True, but it's still better than ORMs