839
JSON Query Language (programming.dev)
submitted 3 months ago by JPDev@programming.dev to c/programmer_humor@programming.dev
48 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[-] ShortFuse@lemmy.world 2 points 3 months ago* (last edited 3 months ago)

Either do a left join and repeat all the post values for every tag or do two round-trip queries and manually join them in code.

JSON_ARRAYAGG. You'll get the object all tidied up by database in one trip with no need to manipulate on the receiving client.

I recently tried MariaDB for a project and it was kinda neat, having only really messed with DynamoDB and 2012 era MsSQL. All the modern SQL languages support it, though MariaDB and MySQL don't exactly follow the spec.

this post was submitted on 27 Jul 2024
839 points (97.8% liked)

Programmer Humor

19454 readers
17 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
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev