Database Detective: Minor Crimes Division

i find the premise of the game to be exactly my thing and the puzzles to be quite enjoyable all in all, but i'll stop coping and set things straight: because the game has so little qol/ux i can't see myself continue playing it. currently i have to fight my own habits which makes the game feel like a chore more than anything and my whole body rejects opening the game because of that. firstly i'd like to say that i'm not the kind of person that doesn't give second chances or leaves a negative review and never updates it, if enough of the issues stated below are resolved i will turn this into a positive review as soon as possible. even though i know the game's supposed to play in 1998 (where things were different), here are some qol/ux suggestions i have, that i'd like to still see implemented: - able to resize any puzzle related window (doesn't have to change the layout dynamically just add/remove scroll bars) - browser tabs - simple browser history - native support for non-qwerty keyboards (mine is qwertz and i have to do ctrl + y to undo something) or able to rebind shortcuts - ctrl/alt + backspace for whole word deletion (in the sql editor) - select text then press tab to indent (or shift + tab to un-indent) for (multiple) rows - show the whole name of desktop files on hover (or at least on single click) now here are some minor qol features that aren't strictly necessary but can be thought about whether to add them sometime in the future: - support more sql commands/functions (for example: between, full outer join, case when, etc.) - able to chain multiple queries (separated by a semicolon) - able to write inline comments using "--" - sql table window grouping (through tabs for example; so it's not a necessity to have 10 windows open simultaneously just for sql tabels on certain levels) - able to increase the audio message volume even higher

SELECT names.first, names.last FROM reviews JOIN names ON reviews.id = names.id WHERE reviews.rating = "Negative" ... YOU ARE COMMANDED to arrest Some Guy under the accusation of leaving a negative review on Database Detective, violating 118 LZ MC 993(a) which prohibits disparaging the name of amazing games made in the great Los Zorangeles.

An excellent game and learning tool for SQL. I learned SQL in class but have not had many opportunities to apply it in practice, so this game has helped me refresh my knowledge and strengthen my skills in a fun, engaging environment. This is a great example of gamified learning done right.

It can be really entertaining but unfortunately, in Chapter 5 the spike in complexity is just too much for my non-programmer brain. The manual becomes a bit useless as it's missing examples for the most confusing parts, leaving me stuck trying again and again. All that would be fine if not for the most irritating part: once you submit a decision (and fail), you cannot go back to what you did. You have to start ALL OVER AGAIN. Maybe for IT people it's okay, but as someone using SQL for the first time, it's hard to even understand what I'm doing wrong. Love the concept, love the humor, and love that deep voice narrating everything, but it would have been nice to get a few smaller bits to get accustomed to smaller chunks instead of suddenly dumping 4 pdf pages of jargon. And it would be REALLY nice to see how it was intended to be solved. As something fun for SQL guys, it must be really fun. As a learning too? Not good. Not. Good.

This is so fun for someone learning SQL :D Great humor, nice voice acting; just an amazing concept. Would recommend.

One of the best indie games I've played so far. Even with strong SQL knowledge, the game is challenging because the main part isn't writing queries - it's the investigation. You feel like you're dealing with some strange production issue that you have to resolve, but without any input data or steps to reproduce it. Step by step, you get closer to the answer, on a journey full of humor and references. Absolutely incredible work, thanks Thomas Hsu.

Database Detective is a very unique game that more than likely has no equal - a detective game a-la The Roottrees are Dead/Return of the Obra Dinn, but where you write SQL queries to help you in solving each case. The game is very goofy & tongue in cheek, so if you're not expecting a serious story & good with that, and enjoy detective games and either know SQL or want to learn it (the game has a manual which is quite good), this game is perfect for you.

A lot of fun even if you already know SQL. I think there might have been a gas leak when the dev made the MMO chapter but the rest was inspired. p.s. union is implemented but not documented. it came in handy a couple of times