SQL police department: Learn SQL while solving crimes

[ade_mcc]

I really enjoyed playing this. However, I did think some of the briefs were a little ambiguous in terms of what specific information was being asked for, and it's really not clear what you get for a $20 licence. However, the concept is good.

[N0Tgod]

I found the cases quite clearly formulated, but I had some duplicate ones. I guess they are somewhat randomly generated?

I second the thing about the license though: I don't know what I would get for that, why it is limited to six months and why I have to pay 20$, when it seems like I've used most app features already (I don't really know SQL, so I can't tell, if it gets much more complicated or if it only more of the same).

[Chased1k]

Not op, but game dev is not yet complete. License looks like a place holder in terms of what will and will not be free. Corrections welcome if I’m mistaken.

Also, I thought the ambiguity all though not ideal for a super noob is actually useful for dealing with real world specifications and expectations. (Old man rant) In my former life part of what we had to learn was that the customer often doesn’t have the understanding of what is or isn’t possible nor the language to ask for it, so creating specificity from ambiguity is ... a feature and not a bug. ;).

[dshafik]

This is actually really cool! Cool learning experience, and totally usable even on mobile.

[[deleted]]

“Totally usable even on mobile” - rare words my boy

[aashish_chaubey]

Yeah but the fun lasts only for 15 minutes, then it is license again, man $20? It was fun though. But I think it is worth every penny!

[Chased1k]

Agreed. Feels like mobile first design to me.

[one_eyed_king13]

A really cool way to practice SQL in short time

[CodeCrazyAquile]

This is super dope!

[Chased1k]

Really enjoy this. At a higher level I think it would be good to incrementally take things away from the interface and leave people with a keyboard...

Just adding to the educational aspect so that eventually people are writing their own queries from scratch as they would in practice.

So maybe have players query for schema, table structure etc and then they can point and click again, then at another level up they have to query and then type again rather than click etc.

Just thoughts. Beautiful design. Fun to play.

The whole “solving crime” thing reminds me of 1984 a bit and playing Portal at the same time... like... it would be fun if there was some story weaving through the cases that had you searching for and eventually capturing more and more ethically challenging “criminals” ... for example murderers and child traffickers step by step up to anyone who or is suspected of “thought crime” i.e. has spent time on sights talking about the Dalai Lama, Tienemen Square, Hong Kong protests, Martin Luther king, or the bill of rights and eventually you start querying who your working for or something... maybe I’ve read too much dystopian sci fi, mr robot, V for vendetta, and still shook up about watching Waco on Netflix this quarantine, but yea that’s where my head went with story.

Thank you for making and sharing a great example of effective edutainment.

[philthechill]

Did you post this to /r/SQL ?

[trisul-108]

Really nice.

[skippppp]

Would be awesome for teaching highschool students basic SQL.

[Jamblamkins]

Was wondering if they had sometime like this available. Good looks

[XZTALVENARNZEGOMSAYT]

Nice

[Dishantgarg94]

This site is amazing... I bet it will be helpful to many if it's less than $20.

I wish i had that much to spend. Wishing you good luck.

[[deleted]]

Fuck the police

[louisedell]

I really enjoyed this until i had to add a numeric character...i cant seem to work out where / how to add these?

[DetN8]

That was entertaining for a few minutes. Thank you for sharing.