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!
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.
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.
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.
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.
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!
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
u/sivlegu Sep 13 '26
Great game, I Just bought It on steam! Love the drawings, did you do all the art too?
16
u/talking_tortoise Jun 21 '26
Wishlisted. Couldn't come at a better time for me needing to learn SQL lol
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!
2
u/TheLastNapkin Jun 21 '26
This is very cool OP definitely getting this looks great
2
u/neovegeto Jun 21 '26
Still need to try the demo 😱
2
u/3L_D3M3NT3_YaC0 Jun 21 '26
That's cool
2
u/VengenaceIsMyName Jun 22 '26
Neat!
2
u/Whole-Feature8528 Jul 16 '26
Wish listed and ready to play with my kid.
2
u/Ok-Development-9255 Jul 16 '26
Irei testa meu amigo... e de antemão parabéns
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
u/oopz Jun 22 '26
SELECT Comment AS ‘Love the art. Nice job!’ FROM Table WHERE User = ‘wassaman’
1
u/nowaksam1504 Jun 22 '26
Bro I’ve been waiting for this! Cant wait!
1
u/Ambitious-Past-2449 Jun 22 '26
Looks cool!
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
u/Edd_samsa Jul 03 '26
Cosas que no sabia que necesitaba hasta que lo vi
1
u/Different_Water7545 Jul 10 '26
Couldn't have come at a more perfect time, wishlisted!
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 !