Update 1.14.2
2026-08-28 17:59 UTC · Community Announcements · Train Called Thomas
Bug Fixes:Fixed issue where the ending cutscene wasn't loading
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.
| App ID | 3950130 |
|---|---|
| App type | Game |
| Developer | Thomas Hsu |
| Publisher | Thomas Hsu |
| Release date | 2026-07-17 15:47 UTC |
| Release state | released |
| Store page | store.steampowered.com/app/3950130 |
| Last store refresh | 24 minutes ago |
Launch options
| # | Executable | Arguments | OS | Description |
|---|---|---|---|---|
| 0 | copOS.exe | windows | ||
| 1 | copOS.x86_64 | linux | ||
| 2 | copOS.app | macos |
No player history yet. This app is now tracked, so data will appear within about ten minutes.
| Playing now | Not polled yet (never) |
|---|---|
| 24-hour peak | |
| All-time peak (tracked) |
Regional prices
All Steam store regions, converted to USD at today's exchange rate, compared with the US price. Lowest is the lowest price SteamRaw has recorded for that region.
Loading regional prices…
Price history, US store (USD)
| Date | Price | Regular | Discount |
|---|---|---|---|
| 2026-09-11 21:00 UTC | $11.99 | $14.99 | -20% |
| DLC | AppID | Release | Price |
|---|---|---|---|
| No DLC known for this app. | |||
Branches
| Branch | Build ID | Description | Updated | Password |
|---|---|---|---|---|
| public | 24998064 | 2026-08-28 17:55 UTC | ||
| decktest | 24872699 | Steam Deck Test Branch | 2026-08-21 23:31 UTC |
Depots
| Depot | Name | OS | Size | Download | Public manifest | Notes |
|---|---|---|---|---|---|---|
| 3950131 | 64 · english | 1.50 GB | 174.36 MB | 5008819563426202732 | branches: decktest | |
| 3950132 | macos · 64 · english | 1.51 GB | 180.58 MB | 6838111987978612800 | branches: decktest | |
| 3950133 | linux · 64 · english | 1.49 GB | 169.90 MB | 4632272472218456612 | branches: decktest |
A build is one published version of the game's files on a branch. Steam assigns a new build ID every time the developer pushes an update, so this list is the update history of the app. The files inside a build (depot manifests) are only readable with an account that owns the game, which SteamRaw does not have yet, so build contents are not shown.
| Build ID | Branch | Updated | First seen |
|---|---|---|---|
| 24998064 | public | 2026-08-28 17:55 UTC | 5 hours ago |
| 24872699 | decktest | 2026-08-21 23:31 UTC | 5 hours ago |
Every appinfo change SteamRaw has observed, grouped by changelist. Tags, features, languages, builds, depots, prices and any other key Steam publishes. Tracking since 2026-09-11 21:00 UTC.
No changes recorded since SteamRaw first saw this app. Every future PICS change will be listed here.
| Changelist | Apps | Packages | Seen | What changed |
|---|---|---|---|---|
| No changelists recorded for this app yet. | ||||
Demo Update 2.01
2026-08-26 15:41 UTC · Community Announcements · Train Called Thomas
The demo is now up to date with (most of) the updates from the base game! Also made sure that opening the demo when you have the full game does not delete your entire save file (but it does delete progress in the 4th case since that level shares the level number with the demo credits scene).
Update 1.14.1
2026-08-25 03:52 UTC · Community Announcements · Train Called Thomas
Bug Fixes:Fixed issue where the shift key maps keys to the QWERTY keyboard layout.This was caused by an attempt to fix the shift key not working on the Steam Deck virtual keyboard, so that fix has been undone.
Update 1.14 - Query Tabs!
2026-08-24 22:51 UTC · Community Announcements · Train Called Thomas
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:Gamepla
Update 1.13
2026-08-20 09:14 UTC · Community Announcements · Train Called Thomas
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 Shift+Tab to Tab+Z.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 Fixes:Fixed issue where
Update 1.12 - Additional Taskbar Functionality
2026-08-15 17:35 UTC · Community Announcements · Train Called Thomas
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 Shift/Shift+Tab respectively!Update Notes:Gameplay Changes:Add animation for right click dropdownsAdd ability to right click on the taskbar to close a window or hide all windowsAdd ability to indent and unindent selected text in the Search Tables windowAlt+W now cycles between two most recent windowsBug FixesRight click dropdowns are no longer obscured by the taskbarEnsure traveling through time makes message timeline cons
Update 1.11 - Mac Fixes
2026-08-10 15:37 UTC · Community Announcements · Train Called Thomas
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 FixesFix Mac crashing on the last two casesPrevent time traveling from allowing access to chapters that should be lockedRestoring queries from Query History now brings the Search Tables window to the topGameplay Changes:Parser Improvements:Better, more descriptive warningsBlock queries with non-aggregate columns in the
Update 1.10
2026-08-07 16:07 UTC · Community Announcements · Train Called Thomas
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 FixesFix cursor misalignment in the Search Tables window after a long line of text is wrapped aroundFix ending cutscene not loadingFix issue where quoted identifiers were not recognized as valid column names by the parser when written like tableName."columnName"Gameplay Changes:Parser Improvements:Add support for LIMITAdd more specific error messages when a keyword appears after a special character (like a comma) in a FROM or JOIN
Update 1.09
2026-08-05 22:22 UTC · Community Announcements · Train Called Thomas
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 FixesFor the final case:Fix bug which prevented tables from being downloadedGameplay 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 using comm
Update 1.08
2026-08-04 21:29 UTC · Community Announcements · Train Called Thomas
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 of
Update 1.07
2026-08-02 23:05 UTC · Community Announcements · Train Called Thomas
Wanted to get this out quickly to fix a bug introduced in the previous update for the seventh case (with the wiki) preventing you from downloading payup transactions tied from accounts tied to websites. Luckily, this isn't required to solve the case, but if this happened to you, reloading the case should fix things. Update Notes:Gameplay ChangesIncreased maximum length of table names for table iconsBug FixesFor the 7th case (wiki level):Rename payup account tables tied to websites to make sure they can be downloadedFix hint that references an old table name in the last levelFix icon selection
Update 1.06 - Internet History & Bookmarks!
2026-07-31 21:02 UTC · Community Announcements · Train Called Thomas
You can now view your internet history!You can also bookmark websites which will show up in your internet history.Also, clicking on a website in a table will bring up that website in a web browser automatically. Clickable websites will have underlined blue text when hovered over (like below). Many more updates to come!Update Notes:Gameplay ChangesAdd internet history and ability to bookmark websitesTables containing websites now automatically opens the website when clickedAdd sound effects when restoring or deleting from query historyBug FixesCtrl+Enter now only works when the Search Tables wi
Update 1.05 - Preserve Tables on Failure
2026-07-25 18:35 UTC · Community Announcements · Train Called Thomas
Trying again should no longer drop the tables you created or reload the case.This is also true with switching between cases, with one big caveat: this only affects cases that have been loaded after this update. This means that if you played the first case before this update and now are on the second case, your tables for the second case will be preserved but not the tables for the first case if you switch back to it. However, if you played the first case after this update, you should be able to switch to it without losing progress.In other words, your current progress should not be affected bu
Update 1.04.1 - Remove Dev Window
2026-07-24 14:41 UTC · Community Announcements · Train Called Thomas
Whoops, did not mean to do that!Update Notes:Gameplay ChangesDisable Dev Window
Update 1.04
2026-07-24 06:07 UTC · Community Announcements · Train Called Thomas
More bug fixes! Notably fixed the bug where Linux builds of the game were missing SQLite functions.Next update will focus on quality of life improvements such as preserving progress if you get a case wrong.Update Notes:Gameplay ChangesReduce assistant's thinking time before and between hintsBring up Steam Deck virtual keyboard when an input field is clickedImprove how default table names are generatedBug FixesFix missing SQLite functions on LinuxHuge thank you to neattaken for helping out with this!Fix unsaved tables not having syntax highlightingFix Webtrotter achievement not unlockingFor the
Full appinfo as delivered by Steam PICS, changenumber 38635980. Also at /api/app/3950130/raw.
{
"appid": "3950130",
"common": {
"name": "Database Detective: Minor Crimes Division",
"type": "Game",
"icon": "05908d206c4b91d5d5e59ea5b52a15dd6773c3ac",
"clienticon": "05908d206c4b91d5d5e59ea5b52a15dd6773c3ac",
"linuxclienticon": "4f15ad7b405794a19f3ebb636d46745d4b3642d4",
"clienticns": "4f15ad7b405794a19f3ebb636d46745d4b3642d4",
"releasestate": "released",
"oslist": "windows,macos,linux",
"osarch": "64",
"osextended": "macos64",
"steam_deck_compatibility": {
"category": "2",
"steamos_compatibility": "2",
"steam_machine_compatibility": "2",
"test_timestamp": "1784592000",
"tested_build_id": "24281182",
"tests": {
"0": {
"display": "3",
"token": "#SteamDeckVerified_TestResult_DefaultControllerConfigNotFullyFunctional"
},
"1": {
"display": "3",
"token": "#SteamDeckVerified_TestResult_ControllerGlyphsDoNotMatchDeckDevice"
},
"2": {
"display": "3",
"token": "#SteamDeckVerified_TestResult_TextInputDoesNotAutomaticallyInvokesKeyboard"
},
"3": {
"display": "3",
"token": "#SteamDeckVerified_TestResult_InterfaceTextIsNotLegible"
},
"4": {
"display": "3",
"token": "#SteamDeckVerified_TestResult_NotFullyFunctionalWithoutExternalKeyboard"
},
"5": {
"display": "4",
"token": "#SteamDeckVerified_TestResult_DefaultControllerConfigFullyFunctional"
},
"6": {
"display": "4",
"token": "#SteamDeckVerified_TestResult_DefaultConfigurationIsPerformant"
},
"7": {
"display": "1",
"token": "#SteamDeckVerified_TestResult_ExternalControllersNotSupportedLocalMultiplayer"
}
},
"steam_machine_tests": {
"0": {
"display": "3",
"token": "#SteamMachine_TestResult_DefaultControllerConfigNotFullyFunctional"
},
"1": {
"display": "3",
"token": "#SteamMachine_TestResult_ControllerGlyphsDoNotMatchDevice"
},
"2": {
"display": "3",
"token": "#SteamMachine_TestResult_TextInputDoesNotAutomaticallyInvokesKeyboard"
},
"3": {
"display": "3",
"token": "#SteamMachine_TestResult_NotFullyFunctionalWithoutExternalKeyboard"
},
"4": {
"display": "4",
"token": "#SteamMachine_TestResult_DefaultControllerConfigFullyFunctional"
},
"5": {
"display": "4",
"token": "#SteamMachine_TestResult_DefaultConfigurationIsPerformant"
}
},
"steamos_tests": {
"0": {
"display": "3",
"token": "#SteamOS_TestResult_GameStartupFunctional"
},
"1": {
"display": "1",
"token": "#SteamOS_TestResult_DefaultControllerConfigNotFullyFunctional"
},
"2": {
"display": "1",
"token": "#SteamOS_TestResult_TextInputDoesNotAutomaticallyInvokesKeyboard"
},
"3": {
"display": "1",
"token": "#SteamOS_TestResult_ExternalControllersNotSupportedLocalMultiplayer"
},
"4": {
"display": "1",
"token": "#SteamOS_TestResult_NotFullyFunctionalWithoutExternalKeyboard"
}
},
"configuration": {
"supported_input": "other",
"requires_manual_keyboard_invoke": "1",
"requires_non_controller_launcher_nav": "0",
"primary_player_is_controller_slot_0": "0",
"non_deck_display_glyphs": "1",
"small_text": "1",
"requires_internet_for_setup": "0",
"requires_internet_for_singleplayer": "0",
"recommended_runtime": "proton-11.0-beta",
"requires_h264": "0",
"requires_voice_files": "0",
"gamescope_frame_limiter_not_supported": "0",
"hdr_support": "0",
"requires_proton_soundfonts": "0"
}
},
"controllertagwizard": "1",
"small_capsule": {
"english": "abba12ba96dac7b570d818bc8c7c6ffb719b6d86/capsule_231x87.jpg"
},
"header_image": {
"english": "ed5315c85ccaeaa8deb05aa6a91fc08e245d1e05/header.jpg"
},
"library_assets": {
"library_capsule": "en",
"library_hero": "en",
"library_hero_blur": "en",
"library_logo": "en",
"library_header": "en",
"logo_position": {
"pinned_position": "CenterCenter",
"width_pct": "33.42245431490281",
"height_pct": "75.93823938743151"
}
},
"library_assets_full": {
"library_capsule": {
"image": {
"english": "ed3cd457aec6ffe5293489e568f1f226e8860e46/library_capsule.jpg"
},
"image2x": {
"english": "ed3cd457aec6ffe5293489e568f1f226e8860e46/library_capsule_2x.jpg"
}
},
"library_hero": {
"image2x": {
"english": "ea0cafa06ceb589b3616806a2a2a0231912134bd/library_hero_2x.jpg"
},
"image": {
"english": "ea0cafa06ceb589b3616806a2a2a0231912134bd/library_hero.jpg"
}
},
"library_hero_blur": {
"image": {
"english": "ea0cafa06ceb589b3616806a2a2a0231912134bd/library_hero_blur.jpg"
}
},
"library_logo": {
"image": {
"english": "5c33998872da0cee5592662cfa7badff59eae54b/logo.png"
},
"image2x": {
"english": "5c33998872da0cee5592662cfa7badff59eae54b/logo_2x.png"
},
"logo_position": {
"pinned_position": "CenterCenter",
"width_pct": "33.42245431490281",
"height_pct": "75.93823938743151"
}
},
"library_header": {
"image": {
"english": "ed5315c85ccaeaa8deb05aa6a91fc08e245d1e05/library_header.jpg"
},
"image2x": {
"english": "ed5315c85ccaeaa8deb05aa6a91fc08e245d1e05/library_header_2x.jpg"
}
}
},
"store_asset_mtime": "1773637550",
"associations": {
"0": {
"type": "developer",
"name": "Thomas Hsu"
},
"1": {
"type": "publisher",
"name": "Thomas Hsu"
}
},
"primary_genre": "23",
"genres": {
"0": "23"
},
"category": {
"category_2": "1",
"category_22": "1",
"category_23": "1",
"category_68": "1",
"category_79": "1",
"category_62": "1"
},
"supported_languages": {
"english": {
"supported": "true",
"full_audio": "true",
"subtitles": "true"
}
},
"steam_release_date": "1784303267",
"community_visible_stats": "1",
"community_hub_visible": "1",
"gameid": "3950130",
"store_tags": {
"0": "5432",
"1": "1664",
"2": "492",
"3": "1036",
"4": "8369",
"5": "6129",
"6": "5613",
"7": "1719",
"8": "3871",
"9": "4182",
"10": "5030",
"11": "5716",
"12": "4562",
"13": "5372",
"14": "6815"
},
"review_score": "9",
"review_percentage": "97"
},
"extended": {
"developer": "Thomas Hsu",
"publisher": "Thomas Hsu"
},
"config": {
"installdir": "Database Detective",
"launch": {
"0": {
"executable": "copOS.exe",
"config": {
"oslist": "windows"
}
},
"1": {
"executable": "copOS.x86_64",
"type": "default",
"config": {
"oslist": "linux"
}
},
"2": {
"executable": "copOS.app",
"type": "default",
"config": {
"oslist": "macos"
}
}
},
"app_mappings": {
"0": {
"platform": "linux",
"tool": "SteamLinuxRuntime_4"
}
}
},
"depots": {
"3950131": {
"config": {
"language": "english",
"osarch": "64"
},
"manifests": {
"public": {
"gid": "5008819563426202732",
"size": "1608918268",
"download": "182834272"
},
"decktest": {
"gid": "2964443200946604255",
"size": "1577262688",
"download": "180306160"
}
}
},
"3950132": {
"config": {
"language": "english",
"oslist": "macos",
"osarch": "64"
},
"manifests": {
"public": {
"gid": "6838111987978612800",
"size": "1621673513",
"download": "189348960"
},
"decktest": {
"gid": "1703381582570642232",
"size": "1556762215",
"download": "182251792"
}
}
},
"3950133": {
"config": {
"language": "english",
"oslist": "linux",
"osarch": "64"
},
"manifests": {
"public": {
"gid": "4632272472218456612",
"size": "1601368626",
"download": "178157392"
},
"decktest": {
"gid": "6094713521839041827",
"size": "1569712563",
"download": "175637888"
}
}
},
"branches": {
"public": {
"buildid": "24998064",
"timeupdated": "1787939734",
"timebuildupdated": "1787939380"
},
"decktest": {
"buildid": "24872699",
"description": "Steam Deck Test Branch",
"timeupdated": "1787355064",
"timebuildupdated": "1787355064"
}
}
},
"ufs": {
"quota": "200000000",
"maxnumfiles": "1000",
"savefiles": {
"0": {
"root": "WinAppDataLocalLow",
"path": "HsuCorp/copOS",
"pattern": "*"
}
},
"rootoverrides": {
"0": {
"root": "WinAppDataLocalLow",
"os": "MacOS",
"oscompare": "=",
"useinstead": "MacAppSupport",
"pathtransforms": {
"0": {
"find": "HsuCorp/copOS",
"replace": "com.HsuCorp.copOS"
}
}
},
"1": {
"root": "WinAppDataLocalLow",
"os": "Linux",
"oscompare": "=",
"useinstead": "LinuxXdgConfigHome",
"pathtransforms": {
"0": {
"find": "HsuCorp/copOS",
"replace": "unity3d/HsuCorp/copOS"
}
}
}
}
}
}