I built SQL Noir, an interactive detective game that challenges you to solve mysteries using real SQL queries. It’s fully open source, designed to give you a practical and immersive way to learn SQL while engaging with a narrative-driven mystery.
Show HN: SQL Noir – Learn SQL by solving crimes
1–10 of 90 posts
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#2This is really lovely. It makes me happy that you invested time into building this for other people.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#3this is awesome! soooo fun. Thank you for building this. Sharing it immediately
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#4Really cute. But I really want the ability to put the different tabs -- Brief, Workspace, Schema -- side-by-side. I know SQL and wanted to play with this, but the UX was frustrating enough to drive me away, even though it is really pretty.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#5This is pretty fun, I tried the two free mysteries and was fun solving them. One nit, would be nice if the SQL editor supported comments so we can comment out old queries before running new one so as keeping a history esp if we need to run the same queries again. Good stuff :)
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#6Really cute. But I really want the ability to put the different tabs -- Brief, Workspace, Schema -- side-by-side. I know SQL and wanted to play with this, but the UX was frustrating enough to drive me away, even though it is really pretty.
I agree. I also wish it was possible to run multiple queries in the same window e.g.:
select * from crime_scene;
select * from suspects;Re: Show HN: SQL Noir – Learn SQL by solving crimes
#7This gives me a childhood flashback to a show called MathNet, an educational police procedural (a la Dragnet) where both investigators have holstered calculators.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#8reminds me of https://mystery.knightlab.com/
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#9reminds me of https://mystery.knightlab.com/
An honorable mention. This was in fact my inspiration for creating SQL Noir.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#10This is pretty fun, I tried the two free mysteries and was fun solving them. One nit, would be nice if the SQL editor supported comments so we can comment out old queries before running new one so as keeping a history esp if we need to run the same queries again. Good stuff :)
You should be able to add -- and comment out lines of queries. If not, this is a bug that I will investigate. Also you can use the Notes tab to store any past queries and findings.