this post was submitted on 27 Feb 2025
196 points (99.5% liked)

Programming

19015 readers
164 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev

founded 2 years ago
MODERATORS
snowe@programming.dev
Ategon@programming.dev
MaungaHikoi@lemmy.nz
196
SQL Noir (www.sqlnoir.com)
submitted 2 weeks ago by SlIdE42@jlai.lu to c/programming@programming.dev
16 comments fedilink hide all child comments
 

Solve mysteries through SQL.

top 16 comments
sorted by: hot top controversial new old
[–] em2@lemmy.ml 67 points 2 weeks ago (2 children)

Heck yeah

[–] Aurenkin@sh.itjust.works 19 points 2 weeks ago (1 children)

Push it to the LIMIT

[–] killeronthecorner@lemmy.world 22 points 2 weeks ago 
SELECT few FROM people WHERE gets_joke = 1
[–] SlapnutsGT@lemmy.world 8 points 2 weeks ago (1 children)

I’m a rebel. I write all my sql in lowercase

[–] shasta@lemm.ee 1 points 2 weeks ago (1 children)

Yeah we have IDEs to color keywords for us these days. Caps is just extra work

[–] diemartin@sh.itjust.works 2 points 2 weeks ago

Capital letters are bigger, thus they use bigger bytes and use too much disk space and memory. That's why most programming languages use lowercase, and why the most common loop variable is i.

[–] ichbean@lemm.ee 26 points 2 weeks ago* (last edited 2 weeks ago) (3 children)

If you're new to SQL there's interactive Select Star SQL tutorial. And there's another detective — SQL Murder Mystery

[–] JoeBigelow@lemmy.ca 7 points 2 weeks ago

I know what I'm doing at work today

[–] AnarchistArtificer@slrpnk.net 2 points 2 weeks ago

My gosh, these are incredible. Thank you for sharing them. I cried at Select Star; that is legitimate art.

[–] tpyo@lemmy.world 2 points 2 weeks ago

I have some time to kill before having to run some errands. I've started with the first one and it's pretty fun!

Said "fuck yeah" a couple times to myself when I got the answer right. I've not used SQL before but I've got a decent grasp (as in I get the basics) on programming languages so it's somewhat intuitive to me

Thanks for the links!! I look forward to continuing when I get back

[–] lud@lemm.ee 8 points 2 weeks ago (1 children)

Relevant:

[–] tpyo@lemmy.world 2 points 2 weeks ago

Alt text:

[–] omgitsaheadcrab@sh.itjust.works 6 points 2 weeks ago

Good stuff

[–] pruwybn@discuss.tchncs.de 5 points 2 weeks ago* (last edited 2 weeks ago) (1 children)

I tried to hit F5 to run a query and it refreshed the page lol

edit: I'm also slightly annoyed that the table names are a mix of singular and plural

[–] nebeker@programming.dev 1 points 2 weeks ago

That totally threw me off. “Literally unplayable,” as they say.

[–] recursiveInsurgent@lemm.ee 3 points 2 weeks ago

This seems like it was made specifically for me and my interests.