News for hackers. Stuff that matters.
Re:Show HN: SQL Noir – Learn SQL by solving crimes by chrisBHappy on Thursday February 13, 2025 @05:51PM (#43042485)
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.
Re:Show HN: SQL Noir – Learn SQL by solving crimes by mymacmachine on Thursday February 13, 2025 @06:08PM (#43042647)
Hey!

Firstly - great work - one of my favourite games is Chronicles of Crime and this immediately made me think back to how I would've gone about investigating some of those stories using SQL.

w.r.t the comments - you can add `--` to comment out lines of queries but when I do it on two or more lines they get mashed into a single line and I can't reliably uncomment them again without the queries getting mangled.

I've found you can use multiline comments /* and */ though which worked for me - just a bit more back and forth on the keyboard.

Anyway - again - awesome work.

Re:Show HN: SQL Noir – Learn SQL by solving crimes by chrisBHappy on Thursday February 13, 2025 @06:13PM (#43042687)
Thank you very much. That's actually a great suggestion. I completely forgot about that. As for the single line comments, indeed this is a bug, I'll try to fix it.
Re:Show HN: SQL Noir – Learn SQL by solving crimes by pledg on Thursday February 13, 2025 @06:28PM (#43042804)
It works for the first line, but doing it on a second seems to make it merge lines.
Re:Show HN: SQL Noir – Learn SQL by solving crimes by chrisBHappy on Friday February 14, 2025 @09:26AM (#43048612)
Yep. This was a bug. I just fixed it.