SQL DETECTIVE

Overview

Step into the shoes of a high-tech forensic investigator in SQL Detective. Unlike traditional mystery games, your primary tool isn't a magnifying glass—it's SQL. This is a unique, dual-screen cooperative experience where your PC serves as the central investigation hub and your mobile device acts as your personal terminal.

How to Play (Crucial!)

This game is designed for a Dual-Screen Experience. Please follow these steps to begin your investigation:

  1. Launch on PC: Run the game here in your browser on a Desktop/Laptop.
  2. Get Your Key: Once the game starts, a unique 6-digit Session Key will appear on your PC screen.
  3. Connect via Mobile: Open the mobile controller link (provided in-game) on your smartphone.
  4. Sync: Enter the Session Key on your phone to link the devices.

The Investigation

  • PC Screen (The Hub): Displays the crime scene, suspect profiles, and the results of your database queries.
  • Mobile Screen (The Terminal): Use your phone to write and execute SQL queries. Filter through evidence, cross-reference witness testimonies, and track down the culprit.

Technical Requirements

  • Host: Must be played on a PC/Laptop browser.
  • Controller: Requires a Smartphone with an active internet connection.
  • Connection: Both devices communicate via a cloud-based relay for seamless interaction.

Credits & Tech Stack

  • Engine: Unity (WebGL)
  • Backend: .NET Core API hosted on Railway
  • Database: Supabase (PostgreSQL)
More information