this post was submitted on 19 Oct 2023
1613 points (98.7% liked)

Programmer Humor

32429 readers
837 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] fmstrat@lemmy.nowsci.com 30 points 1 year ago (3 children)

This doesn't make sense to me. SPs and functions are in every major database. If I wrote a bash script that runs like a program, and sounds like a program, did I program it? Script it?

And lots of systems have nested logic in the DB, optimization often leads to that to reduce overhead. Unless you're being lazy with an ORM like prisma that can't even join properly.

Getting high performing queries is just as difficult as any other programming language, and should be treated as such. Even Lemmy's huge performance increases to .18ish came from big PG optimizations.

[–] mbp@lemmy.sdf.org 11 points 1 year ago

It seems to be about yelling at others that "you're not a real programmer!!!" mixed with being so "technically correct" my eyes can no longer roll the same way they used to.

[–] Random_user@lemmy.world 4 points 1 year ago

It's mostly ignorance. People tend to underestimate or dismiss things they don't completely understand.

[–] rwhitisissle@lemmy.ml 0 points 1 year ago (1 children)

Admittedly, this discussion is more one of semantics than anything. It's pretty clear I'm arguing that SQL is not a "General Purpose Language," and that proficiency in that domain is what constitutes programming. Which, yeah, is arguably somewhat arbitrary. But my point is that, colloquially, someone who only works with SQL isn't a programmer. Data Engineer, sure. DBA. Also, sure. Depends on what you do. Programmer? Not really. Not unless you (as in the person, not "it's theoretically possible") can use raw SQL to read in video data from a linux system device file and then encode it to mp4 and just nobody's told me.

[–] fmstrat@lemmy.nowsci.com 3 points 1 year ago

Do that in Javascript. Or HTML. Or CSS. Or by that logic is a web developer not a programmer? What about microcontroller programmers?

I could easily write a full logic program in SQL where the API just feeds it data, which is the inverse of how you treat SQL. Admittedly that's not as common, but it happens pretty frequently in areas of big data, like medical.

I've hired Senior Software Engineers that were DBAs, and others that weren't. They were a development team, all programmers in their own right.