this post was submitted on 27 Dec 2023
376 points (96.1% liked)

Programmer Humor

19187 readers
1113 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 1 year ago
MODERATORS
[email protected]
[email protected]
[email protected]
376
no.. just no (lemmy.ca)
submitted 8 months ago by [email protected] to c/[email protected]
52 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 23 points 8 months ago (3 children)

if you don't believe that adding more structure to the absolute maniacal catastrophe that is sql is a good thing then i'm going to start to have doubts about your authenticity as a human being

[–] [email protected] 2 points 8 months ago* (last edited 8 months ago) (4 children)

Me trying to remember on whose output data having, count, sum, etc. work

Once you know functions you would have no reason to go back.
I propose we make SQL into this:

const MAX_AMOUNT = 42, MIN_BATCHES = 2

database
    .from(table)
    .where(
        (amount) => amount < MAX_AMOUNT,
        table.field3
    )
    .select(table.field1, table.field3)
    .group_by(table.field1)
    .having(
        (id) => count(id) >MIN_BATCHES
        table.field0
    )

(Sorry for any glaring mistakes, I'm too lazy right now to know what I'm doing)

..and I bet I just reinvented the wheel, maybe some JavaScript ORM?

[–] [email protected] 2 points 8 months ago (1 children)
[–] [email protected] 1 points 8 months ago* (last edited 8 months ago)

Thanks for the suggestion! It looks interesting, not quite what I expected looking at that file*, but that may very well be better

Edit: other examples seem a bit more similar to mine, cool!

[–] [email protected] 2 points 8 months ago* (last edited 8 months ago) (2 children)

Because you never learned SQL properly, from the sound of it.

Also, ORMs produce trash queries and are never expressive enough.

[–] [email protected] 3 points 8 months ago* (last edited 8 months ago)

Because you never learned SQL properly, from the sound of it.

You might be right, though, to be fair, I also keep forgetting syntax of stuff when I don't use it very often (read SQL (._.`))

Also, ORMa produce trash queries and are never expressive enough.

I meant to say that I would like the raw SQL syntax to be more similar to other programming languages to avoid needing to switch between thinking about different flows of logic

[–] [email protected] 2 points 8 months ago

ORMs produce good queries if you know what you do. Which requires proper knowledge of SQL, unfortunately.

[–] [email protected] 2 points 8 months ago

most languages have some first or third party lib that implements a query builder

[–] [email protected] 1 points 8 months ago

No. The arrow function in where eliminates any possibility of using indexes. And how do you propose to deal with logical expressions without resorting to shit like .orWhereNot() and callback hell? And, most importantly, what about joins?

[–] [email protected] 0 points 8 months ago (1 children)

Huh? Sql is one of the most powerful, action packed (as in you can move lots of shit with few commands) languages out there.

It's transferable and ubiquitous.

[–] [email protected] 1 points 8 months ago (1 children)

powerful isn't the same as well-structured

it was written to be a language that anybody could read or write as well as english, which just like every other time that's been tried, results in a language that's exactly as anal about grammar as C or Python except now it's impossible to remember what that structure is because adding anything to the language to make that easier is forbidden

when you write a language where its designers were so keen for it to remain human readable that they made deleting all rows in a table the default action, i don't think "well structured" can be used to describe it

[–] [email protected] 1 points 8 months ago

Disagree, the difference between "week structured" and needing to know the rules of the verbs is pretty big, to me.

[–] [email protected] -1 points 8 months ago* (last edited 8 months ago) (2 children)

but sql doesn't need to be structured that's what abstraction layers and models are for

[–] [email protected] 9 points 8 months ago

SQL is literally structured query language

[–] [email protected] 8 points 8 months ago

SQL is incredibly structured. It's also a very good language, and developers need to stop piling on junk on top of it and producing terrible queries. Learn the damn language. It's not that hard