Heya (also from TO ), I had something similar in mind when I built https://www.producthunt.com/products/hitechjobsca , had to shut it down during covid but happy to connect and brainstorm ideas in the Hrtech space if you are up for it. Contact in profile.
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 :)
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.
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.
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.
Perfectly cooked eggs every single time, bought this in 2014 still going strong: KRUPS F23070 Egg Cooker with Water Level Indicator, 7-Eggs Capacity, White https://www.amazon.ca/dp/B00005KIRS/
