this post was submitted on 27 Dec 2023
484 points (96.7% liked)

Programmer Humor

24373 readers
581 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 2 years ago
MODERATORS
 
top 50 comments
sorted by: hot top controversial new old
[–] Witchfire@lemmy.world 131 points 2 years ago* (last edited 2 years ago) (4 children)

Honestly more readable than a lot of SQL I've read. It even has hierarchical grouping.

[–] reimufumo@lemmy.ca 3 points 2 years ago (1 children)

true, but having it look like a component might get annoying. since this is likely to stay at the top, having an island of non components between two components might make it hard to see where functions start and end. and if this isn't used directly inside a component it'll just look dumb and inefficient (this also looks like it'll take way more to edit once you change something)

[–] bahbah23@lemmy.world 2 points 2 years ago* (last edited 2 years ago) (1 children)

I think I agree with you both. I'm not a Node developer; could you keep your SQL objects/components in a separate file so that they don't clutter up other logic?

load more comments (1 replies)
load more comments (3 replies)
[–] cmdrkeen@programming.dev 70 points 2 years ago

Honestly not the worst thing I’ve seen.

[–] akash_rawal@lemmy.world 36 points 2 years ago (2 children)

I actually like this. This would allow reuse of all the infrastructure we have around XML. No more SQL injection and dealing with query parameters? Sign me up!

[–] CanadaPlus@futurology.today 8 points 2 years ago

Assuming it's built well. As someone else pointed out, it doesn't look quite right here.

[–] utopianfiat@lemmy.world 5 points 2 years ago (3 children)

So you mean like parameterized queries, which exist?

load more comments (3 replies)
[–] expr@programming.dev 35 points 2 years ago (1 children)

Not only is this really gross, it's also straight up wrong. It's missing a from clause, and it makes no sense for a where clause to be nested under the select. The select list selects columns from rows that have already been filtered by the where clause. Same for the limit.

Also just gonna go ahead and assume the JSX parser will happily allow SQL injection attacks...

[–] CanadaPlus@futurology.today 3 points 2 years ago (2 children)

I like the format, though.

load more comments (2 replies)
[–] RustyNova@lemmy.world 35 points 2 years ago

Ah yes. That's what the kids call "sqlx" right?

NGL, if it has real time code completion and compile time SQL checks, this is fine.

[–] namelivia@lemmy.world 28 points 2 years ago* (last edited 2 years ago)

When you are assigned to write database queries at work and your academical background is that online react bootcamp

[–] Primarily0617@kbin.social 25 points 2 years ago (21 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

[–] Solemarc@lemmy.world 24 points 2 years ago

If you think this is more structured than traditional SQL, I really disagree. Is this a select * query, it's ambiguous. Also what table is being queried here there's no from or other table identifier.

load more comments (20 replies)
[–] mvirts@lemmy.world 23 points 2 years ago (1 children)

Remember kids, JSX is just function calls. It can't hurt you.

[–] Thcdenton@lemmy.world 16 points 2 years ago

Oh it can and it did.

[–] kpw@kbin.social 17 points 2 years ago (1 children)

The most offensive thing here is the amount={5} attribute. What is it? It's not XML.

[–] ABC123itsEASY@lemmy.world 19 points 2 years ago (1 children)

It's a react component and that would be the proper way to give a numerical value in jsx

[–] Huschke@lemmy.world 5 points 2 years ago

JSX has grown beyond react, so without further context it doesn't have to be react.

[–] cupcakezealot@lemmy.blahaj.zone 16 points 2 years ago (1 children)

please kindly send all javascript into the sun and explode it

[–] db2@lemmy.world 3 points 2 years ago (1 children)

That's XML though.. not that I'm disagreeing.

[–] huginn@feddit.it 24 points 2 years ago (3 children)

Not XML. JSX. It's javascript's answer to markup.

[–] db2@lemmy.world 9 points 2 years ago (1 children)
[–] dukk@programming.dev 9 points 2 years ago

The worst of both worlds…

load more comments (2 replies)
[–] normalexit@lemmy.world 14 points 2 years ago (3 children)

This idea is bad and whoever came up with it should feel bad.

load more comments (3 replies)
[–] adhocfungus@midwest.social 14 points 2 years ago
[–] BoastfulDaedra@lemmynsfw.com 12 points 2 years ago

I haven't been this pissed off since LINQ started allowing syntax switches in random-ass places.

[–] JoYo@lemmy.ml 12 points 2 years ago

still more readable than sqlalchemy exceptions

[–] Thcdenton@lemmy.world 12 points 2 years ago
[–] mlg@lemmy.world 11 points 2 years ago

"HTTP and the Web is a totally reliable and easy to use internet protocol"

[–] dylanTheDeveloper@lemmy.world 11 points 2 years ago

Omg that's terrible! Link?

[–] istoff@lemmy.world 6 points 2 years ago

Is that select * ?

I expect it looks more cumbersome with joins and multiple columns from different tables.

[–] leftzero@lemmynsfw.com 5 points 2 years ago

Of course not... where's the damn tag..?

[–] SaltyIceteaMaker@iusearchlinux.fyi 4 points 2 years ago (3 children)

got no clue abot sql. what is wrong and how is it supposed to look like?

[–] Daxtron2@startrek.website 15 points 2 years ago

this basically xml being made to look like SQL. It's gross and that's why it's funny

[–] schnurrito@discuss.tchncs.de 5 points 2 years ago

SQL is supposed to look like this: SELECT status, name FROM some_table LIMIT 5

[–] ILikeBoobies@lemmy.ca 3 points 2 years ago* (last edited 2 years ago)

Different language

Sharepoint queries are written in something very similar 🤢

I still have nightmares from the one time I had to use that.

[–] Reptorian@programming.dev 2 points 1 year ago

I kind of like it. I can understand where it start and end.

load more comments
view more: next ›