Comment by chocks

9 days ago

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 :)

5 comments

chocks

Reply
chrisBHappy  9 days ago

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.

  • mymacmachine  9 days ago

    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.

    • chrisBHappy  9 days ago

      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.