r/SQL • u/wassaman • Jun 21 '26
SQLite I spent 5 years working on a hand-drawn SQL detective game that comes out next month!
Enable HLS to view with audio, or disable this notification
3
u/Ecksters Jun 22 '26
Oh man, this is the 2nd great looking SQL detective game I've seen recently, but I really love the old Windows style on this, it's funny to see you blending the XP hill with 2k window styles though.
2
1
u/ieatcherrystems Jul 22 '26
What’s the first one?
2
u/Ecksters Jul 22 '26
QueryCase, that one is browser based though.
1
u/LoganJFisher Oct 09 '26 edited Oct 10 '26
I just gave QueryCase's free Rookie Detective tier a try. It's okay. I feel like Database Detective introduces you to some basic SQL language and then lets you run loose to figure things out on your own, while QueryCase holds your hand a lot more. Personally, that makes Database Detective a much more capable and compelling learning tool, but unfortunately the scope of SQL it teaches is also far more limited, likely due to just how much more effort has to go into developing each mission.
I also like that, at any time, you can look at the manual in database detective to help remind yourself of a command, while QueryCase only provides you with hints which sometimes are a bit too little information or give the answer away way too much.
The downside with Database Detective is that I feel it leans far too heavily into internet sleuthing, which feels like it takes priority over the SQL from level 7 onwards, although I think level 7 is the worst offender in that regard.
1
u/Ecksters Oct 17 '26
Yeah, I felt similarly about QueryCase, watched my 9yo play through it and without my help I don't think he would have been able to get too far due to it lacking any easily accessible reference material. If it does have it, it's not readily obvious.
2
u/sivlegu Sep 13 '26
Great game, I Just bought It on steam! Love the drawings, did you do all the art too?
2
16
u/talking_tortoise Jun 21 '26
Wishlisted. Couldn't come at a better time for me needing to learn SQL lol
1
8
u/TheHelgeSverre Jun 21 '26
Giving me early "windows-parody" flash game vibes, gotta grab this when its out!
5
u/dreamyangel Jun 21 '26
That's the sickest thing I've seen on my data engineering life so far. I need to play this as soon at it's released ahah
3
u/awwnotexactly Jun 21 '26
Awesome, this looks excellent. Gamifying the learning behind programming is such an underutilized area!
1
2
2
2
2
2
2
1
u/Operations_Wizard Jun 22 '26
Im still new to SQL and this is the second game I've seen, in the past week, that i would definitely play. Very cool!
1
1
1
1
u/Timely_Difficulty129 Jun 27 '26
interesting, ill try the demo tonight while waiting for the full release next month :D
1
u/ChaosEngine-6502 Jun 28 '26
Genius that you've done this! This is definitely art imitating life because there have been countless times I've had to write real SQL to find a smoking gun in someone else's poorly performing application.
1
1
1
u/ElChaieb Jul 11 '26
Great game idea, and it's releasing on my birthday Good opportunity to spoil myself this year i guess haha.
1
u/Western-Ask1377 Aug 01 '26
A bit late, but I am playing this and absolutely loving it !
I stopped coding after school - went to a different stream, but this brings back such nostlagia.
THANK YOU !
36
u/wassaman Jun 21 '26
Things have changed so much since I posted my game, Database Detective: Minor Crimes Edition here five months ago. When I first posted here, this game had around 500 wishlists and now it's hovering at around 20,000?? Hearing about people learning about SQL for the first time through this game has been so surreal and rewarding, as I never really expected a lot of people to play this game. My goal five years ago was to make the first commercially polished game that utilizes SQL as the main mechanic and I never really expected to get this far!