DA
Thomas HsuDatabase Detective: Minor Crimes Division
✓ 출처 확인출시됨

Database Detective: Minor Crimes Division

Solve criminal cases through the power of SQL queries! Help out the city of Los Zorangeles by becoming a Database Detective in this new (unpaid) work from home opportunity.

출시일2026. 07. 17
개발Thomas Hsu
플랫폼PC
게임 소개

이 게임에 대해

There’s been a backlog of unsolved cases piling up in the Minor Crimes Division of the Los Zorangeles Police Department and we’ll need a Database Detective to help solve them. We’ll need you to analyze clues and manipulate data using SQL , a database querying language, to figure out who perpetrated crimes from as minor as littering to as serious as not checking out of a hotel after the check-out time. Don’t worry! This role is intended to be accessible for those without any SQL experience , so each Database Detective is given an introductory textbook when they start! This short textbook is less than 20 pages and explains everything that’s needed to solve each case. If you still have trouble writing queries, our comprehensive error messaging system will tell you exactly where your query went wrong, making it easy to correct your mistakes. Still not enough? Each Database Detective is assigned an assistant who’s ready to answer any questions you might have, whether they be about the case itself or the SQL queries you’ll need to write! Understanding how to manipulate data using SQL is not the only part of being a Database Detective ! Your job will also require you to piece together evidence and clues, just like a real detective! Further on in your Database Detective career, you’ll have to sleuth through the internet and piece cases together yourself. Job benefits also include… · Fully voice acted mission briefings at the beginning of each case! · Fully hand drawn art for you to enjoy! · More than 40 websites to explore! · 10 cases for you to solve, each case getting longer and more complex! · A total of around 8-10 hours of valuable work experience to add to your resume!

교육용인디퍼즐싱글 플레이
출시 기록

플랫폼별 일정 이력

게임 타임라인

주요 이벤트

DA
Thomas HsuDatabase Detective: Minor Crimes Division
패치✓ 공식

Update 1.14 - Query Tabs!

Now you can tab between queries in the Search Tables window! With this in place, I'm pretty happy with how things are at the moment and will start working on some larger updates. Barring any other bug fixes or issues that might come up, this means there will probably be longer times between updates. As for what's next, I'll be working on making assets for Steam Community Items for Trading Cards and the Points Shop. After that, I'll start looking at how to integrate Workshop Support to this game. As always, let me know if you have any bugs to report or any additional feedback! Update Notes: Gam

Steam News에서 원문 보기
DA
Thomas HsuDatabase Detective: Minor Crimes Division
패치✓ 공식

Update 1.13

Took a short two day break - now I'm back fixing bugs! As always, please let me know if you notice any more issues. Update Notes: Gameplay Changes: Changed hotkey to unindent selected text from [c]Shift+Tab[/c] to [c]Tab+Z.[/c] Refactored how arrested suspects are tracked. The game should now remember arrested suspects per case. This means you won't be able to arrest the same person twice when you go back to a case. Refactored how valid suspects are tracked. Improved how valid suspects are tracked for each case. This affects the error popup informing you if the suspect is a valid suspect. Bug

Steam News에서 원문 보기
DA
Thomas HsuDatabase Detective: Minor Crimes Division
패치✓ 공식

Update 1.12 - Additional Taskbar Functionality

Now you can right click on the taskbar to close a window or minimize all windows! You'll also be able to indent/unindent selected text in the Search Tables window by pressing [c]Shift[/c]/[c]Shift+Tab[/c] respectively! Update Notes: Gameplay Changes: Add animation for right click dropdowns Add ability to right click on the taskbar to close a window or hide all windows Add ability to indent and unindent selected text in the Search Tables window [c]Alt+W[/c] now cycles between two most recent windows Bug Fixes Right click dropdowns are no longer obscured by the taskbar Ensure traveling through t

Steam News에서 원문 보기
DA
Thomas HsuDatabase Detective: Minor Crimes Division
패치✓ 공식

Update 1.11 - Mac Fixes

This update addresses the crashes that happen on Mac when loading the final two cases. Apologies this took so long for the Mac users, this was probably the most difficult bug fixes that I had to do! If anyone has more issues with Mac builds, please let me know. Update Notes: Bug Fixes Fix Mac crashing on the last two cases Prevent time traveling from allowing access to chapters that should be locked Restoring queries from Query History now brings the Search Tables window to the top Gameplay Changes: Parser Improvements: Better, more descriptive warnings Block queries with non-aggregate columns

Steam News에서 원문 보기
DA
Thomas HsuDatabase Detective: Minor Crimes Division
패치✓ 공식

Update 1.10

Ok I was wrong, it looks like there were more problems! As always, let me know if you're having any unexpected issues and I'll take a look at them. Update Notes: Bug Fixes Fix cursor misalignment in the Search Tables window after a long line of text is wrapped around Fix ending cutscene not loading Fix issue where quoted identifiers were not recognized as valid column names by the parser when written like [c]tableName."columnName"[/c] Gameplay Changes: Parser Improvements: Add support for [c]LIMIT[/c] Add more specific error messages when a keyword appears after a special character (like a com

Steam News에서 원문 보기
DA
Thomas HsuDatabase Detective: Minor Crimes Division
패치✓ 공식

Update 1.09

The most important change here is adding back a semi-colon I accidentally removed in the previous update which caused some issues when downloading tables in the final level. Hopefully there should be no more problems! Ever!!!!! But if there are more issues please let me know. Update Notes: Bug Fixes For the final case: Fix bug which prevented tables from being downloaded Gameplay Changes: Removed syntax highlighting for "LEFT" and "RIGHT" keywords and instead only highlight "LEFT JOIN" and "RIGHT JOIN". Parser Improvements: Specific error messages when trying to access a column from a table us

Steam News에서 원문 보기
DA
Thomas HsuDatabase Detective: Minor Crimes Division
패치✓ 공식

Update 1.08

Wanted to get this out to fix a rare bug that occurs less than 5% of the time in the 8th case (with LZU) causing there to be two valid suspects. This bug occurs when there are two students sitting next to a single smart student with a test score greater than theirs and the texter combined. Sincerest apologies if this happened to you, and if this is currently what you're stuck on, you can hopefully use this detail to get the right suspect: the true culprit has been to exactly 1/4th of the classes. This isn't knowledge required to solve this case, but it might help if you're one of the victims o

Steam News에서 원문 보기
함께 볼 게임

이런 게임도 살펴보세요