Fun! Nice work and will be great to intro newbies to SQL
Show HN: SQL Noir – Learn SQL by solving crimes
51–60 of 90 posts
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#52This gives me a childhood flashback to a show called MathNet, an educational police procedural (a la Dragnet) where both investigators have holstered calculators. https://en.m.wikipedia.org/wiki/Mathnet
and there were infamous hackers too https://youtu.be/vNhBq3kjq_Q?t=2011
Taking advantage of an extra that wasn't charged to the customer?
Ah, that's a classic "use after free" vulnerability.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#53congrats!
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#54What a great idea!
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#55A great addition to a field where there aren't many offerings: SQL Island (https://sql-island.informatik.uni-kl.de) and SQL Murder Mystery (https://mystery.knightlab.com) come to mind. The mechanism of SQL Noir is close to that of the latter, i.e., an undirected, essentially standalone adventure.
I myself am working on SQLab, a SQL game engine that allows you to augment an arbitrary base with exercises on that base to produce directed, standalone adventures: https://github.com/laowantong/sqlab.
You download a dump of the database (currently MySQL, SQLite, Postgres), and can play under any administrator interface. On the same page there's a link to the long police investigation I designed for my (French) students. If you're a teacher or researcher in the field, the principles of SQLab are explained here: https://arxiv.org/abs/2410.16120.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#56I'm a big SQL noob, so I barely know what I'm doing, but... I managed to crash both Firefox and Edge whenever I ran this query:
select * from crime_scene, suspectsRe: Show HN: SQL Noir – Learn SQL by solving crimes
#57Oh this is perfect. I was just looking for exercises to practice my SQL, and detective games are my jam.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#58I like it! Very fun!
Few ideas:
- The "submit" box isn't clear on whether it needs the name or the suspect id for the first case
- It would be nice to have a "copy to notes" button in the output
- It would be nice to have some docs on what functions are available / which dialect this is.
I think this very valuable, it's so much more easy to learn if you actually have a small project to work on
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#59A great addition to a field where there aren't many offerings: SQL Island ( https://sql-island.informatik.uni-kl.de ) and SQL Murder Mystery ( https://mystery.knightlab.com ) come to mind. The mechanism of SQL Noir is close to that of the latter, i.e., an undirected, essentially standalone adventure. I myself am working on SQLab, a SQL game engine that allows you to augment an arbitrary base with exercises on that ba…
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#60Great fun, thank you for building this! Was confused since submitting the confession didn't work, would make sense to ask for the name of the person no?