[HN Gopher] Show HN: SQL Noir - Learn SQL by solving crimes
       ___________________________________________________________________
        
       Show HN: SQL Noir - Learn SQL by solving crimes
        
       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.
        
       Author : chrisBHappy
       Score  : 30 points
       Date   : 2025-02-13 21:49 UTC (1 hours ago)
        
 (HTM) web link (www.sqlnoir.com)
 (TXT) w3m dump (www.sqlnoir.com)
        
       | deanebarker wrote:
       | This is really lovely. It makes me happy that you invested time
       | into building this for other people.
        
       | jppope wrote:
       | this is awesome! soooo fun. Thank you for building this. Sharing
       | it immediately
        
       | ryanianian wrote:
       | Really 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.
        
         | SlackingOff123 wrote:
         | 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;
        
         | chrisBHappy wrote:
         | That's a good suggestion. I'm not sure if screen real estate
         | won't be a problem though.
        
       | chocks wrote:
       | This 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 :)
        
         | chrisBHappy wrote:
         | 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.
        
       | Terr_ wrote:
       | This gives me a childhood flashback to a show called MathNet, an
       | educational police procedural where both investigators have
       | holstered calculators.
       | 
       | https://en.m.wikipedia.org/wiki/Mathnet
        
       | agumonkey wrote:
       | reminds me of https://mystery.knightlab.com/
        
         | chrisBHappy wrote:
         | An honorable mention. This was in fact my inspiration for
         | creating SQL Noir.
        
       ___________________________________________________________________
       (page generated 2025-02-13 23:00 UTC)