I created a free, no-login detective game called **SQL Case Files** to help myself brush up on SQL in a more engaging way than traditional tutorials. In this noir-themed game, players solve crimes by writing real SQL queries. It's a Progressive Web App, so you can add it to your home screen and use it offline once it's loaded. I'd love some honest feedback on a few things: Do you find it engaging? Are the hints and progression clear? And is there anything frustrating or missing that could improve the learning experience? Thank you if you try it out!
8 Answers
This app is incredible from a UX standpoint, especially on mobile! It seems even better than some paid options out there, and it’s free!
As someone whose SQL is just enough for my job, I’m curious if the game uses real SQL logic or if it's all simulated?
This looks really cool! I haven’t delved into SQL much before, but the hints helped me get started, so I’m bookmarking it. Thanks!
Thank you! I'm glad the hints are helpful. I’ve made some improvements, so I hope you enjoy it even more when you come back!
Please consider adding a hint about using Control + Enter to execute the query along with making that a function. It would improve usability a lot!
I’m on it! I’ve made several enhancements recently, so I hope you’ll find it more user-friendly now.
Sounds great! Excited to see those updates!
I checked it out, and I really like the detective theme! However, it would be great if the results of the queries didn’t disappear right after execution; it would help to see them longer while working through the task. But overall, it’s a neat idea!
I've made that change along with other improvements. Hope you’ll come back to enjoy the game even more!
I can’t wait to try this! I really need some practice with SQL. Looks like a fun way to learn for sure!
It looks promising! But I faced some issues: the completed cases aren’t updating correctly, and one of my queries didn’t work as expected. Also, I’d prefer a simpler way to submit my queries since I often hit Ctrl-Enter by instinct. Overall, I’m intrigued and will definitely give it another shot!
Thanks for your feedback! I’ll address the progress bug and the COUNT issue, and I’ll also look into the Ctrl-Enter function. I really appreciate your insights!
I like how you’re actively improving the game! Can't wait to see the updates, especially the query handling!
I’ve completed a few select statements and it seems fun! It's a unique way for people to learn or practice their SQL skills. Can’t comment on everything yet, but you're definitely on the right track!
Thanks for trying it out! I’m looking to strike a good balance between fun and useful practice, so I’d love feedback on the pacing in the later levels.
Good question! The SQL in the game is real and runs on SQLite, so everything you write is executed directly.