this post was submitted on 27 Dec 2023
547 points (96.9% liked)

Programmer Humor

19187 readers
1196 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]
547
no.. just no (lemmy.ca)
submitted 8 months ago by [email protected] to c/[email protected]
95 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 148 points 8 months ago* (last edited 8 months ago) (3 children)

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

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

I was disgusted by the XML at first, but it's a readable query returning a sane JSON object.

Meanwhile, I'm mantaining Java code where the SQL is a perfectly square wall of text, and some insane mofo decided the way to read the resulting list of Object[] 🤮 is getting each column by index... so I'd switch to SQXMLL in a heartbeat.

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

React basically figured out how to make XML work.

Remember, XML was actually designed for use cases like this, that’s why it came with XPath and XSLT, which let you make it executable in a sense by performing arbitrary transformations on an XML tree.

Back in the day, at my first coding job, we had an entire program that had a massive data model encoded in XML, and we used a bunch of XSL to programmatically convert that into Java objects, SQL queries, and HTML forms. Actually worked fairly well, except of course that XSL was an awful language to do that all in.

React simply figured out how to use JavaScript as the transformation language instead.

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

it's a readable query returning a sane JSON object.

No it's not. What table is the data supposed to be coming from..?

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

Check out JOOQ.

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

JOOQ made me realize that most ORMs suck

[–] [email protected] 4 points 8 months 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)

[–] [email protected] 2 points 8 months ago* (last edited 8 months 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?

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

It is so readable that you missed the fact it doesn’t have the FROM clause