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

Programmer Humor

23995 readers
1365 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 1 year ago* (last edited 1 year ago) (4 children)

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

[–] reimufumo@lemmy.ca 3 points 1 year 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 1 year ago* (last edited 1 year 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 1 year ago

Honestly not the worst thing I’ve seen.

[–] akash_rawal@lemmy.world 36 points 1 year 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 1 year ago

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

[–] utopianfiat@lemmy.world 5 points 1 year ago (3 children)

So you mean like parameterized queries, which exist?

load more comments (3 replies)
[–] expr@programming.dev 35 points 1 year 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 1 year ago (2 children)

I like the format, though.

load more comments (2 replies)
[–] RustyNova@lemmy.world 35 points 1 year 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 1 year ago* (last edited 1 year 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 1 year 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 1 year 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 1 year ago (1 children)

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

[–] Thcdenton@lemmy.world 16 points 1 year ago

Oh it can and it did.

[–] kpw@kbin.social 17 points 1 year 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 1 year 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 1 year ago

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

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

please kindly send all javascript into the sun and explode it

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

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

[–] huginn@feddit.it 24 points 1 year ago (3 children)

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

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

The worst of both worlds…

load more comments (2 replies)
[–] normalexit@lemmy.world 14 points 1 year 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 1 year ago
[–] BoastfulDaedra@lemmynsfw.com 12 points 1 year ago

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

[–] JoYo@lemmy.ml 12 points 1 year ago

still more readable than sqlalchemy exceptions

[–] Thcdenton@lemmy.world 12 points 1 year ago
[–] mlg@lemmy.world 11 points 1 year ago

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

[–] dylanTheDeveloper@lemmy.world 11 points 1 year ago

Omg that's terrible! Link?

[–] istoff@lemmy.world 6 points 1 year ago

Is that select * ?

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

[–] leftzero@lemmynsfw.com 5 points 1 year ago

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

[–] SaltyIceteaMaker@iusearchlinux.fyi 4 points 1 year ago (3 children)

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

[–] Daxtron2@startrek.website 15 points 1 year 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 1 year ago

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

[–] ILikeBoobies@lemmy.ca 3 points 1 year ago* (last edited 1 year 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 ›