Yes, I love the idea of gamified learning. I've been working in my free time on gamified learning of git. Will call it something like "Git Commit Crimes". After receiving such a positive feedback for SQL Noir I'll definitely continue to make such games. I might also think about making one for Python since that was requested a couple of times.
Good notes indeed. I have just implemented a side by side view so that you can view 2 tabs at once. I hope this helps. Also as other users suggested you can use the notes for saving queries but you can also comment them out in the editor.
Thank you for the suggestions. I have just implemented the following:
- Side by Side view to open up two different tabs at the same time
- Copy button to copy table names
Haha. You found a cheat code I guess. I would have to think of hiding the answers from plain sight for the next cases or adding some more rows that include these specific strings.
Glad you asked. I don’t want to put a price tag on it because I believe everyone should have access to learning for free. The right to learn shouldn’t be behind a paywall. That said, I’ve added a ‘Buy Me a Coffee’ link for anyone who wants to support the project. No pressure, just an option!
Thank you for pointing that out. During the creation of the cases I did not take much consideration on naming the tables. I will either make all of them plural or singular.
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.
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.