SQL Noir 🔍

Step into the shoes of a real detective and solve crimes using SQL! SQL Noir is an interactive mystery-solving game where you crack cases by writing SQL queries.

About

Welcome to SQL Noir, where you're a data detective solving criminal cases through the power of SQL. Each case file presents you with a unique crime scenario and a database full of evidence. Your mission is to:

• Uncover suspicious patterns in the data
• Track down missing records
• Connect the dots between suspects
• Expose fraudulent transactions
• Piece together the evidence using SQL

Getting Started

1. Clone this repository

2. Install dependencies:

   npm install

3. Go to Supabase and create a new project

4. Copy the generated anon public key and Project URL from the project

5. Create a .env.local file at the root of the project and set the following environment variables:

   VITE_SUPABASE_ANON_KEY=your_anon_key
   VITE_SUPABASE_URL=your_supabase_url

6. Install Supabase CLI:

   • Follow the instructions at Supabase CLI

7. Login to Supabase:

   supabase login

8. Link your project ( You need to be in the root of the project to run this command ):

   supabase link

   • Select the project you just created when prompted

9. Run database migrations:

   supabase db push

10. Start the development server:

    npm run dev

11. Open your browser and navigate to http://localhost:5173

Case Files

Each case in SQL Noir is a unique crime that needs solving. Cases range from simple thefts to complex murders, organized by difficulty level. Put your SQL skills to the test and climb the ranks from rookie to master detective.

Join the Detective Agency

We welcome new detectives! Whether you want to:

• Submit new cases for others to solve
• Improve existing investigations
• Fix bugs in the system
• Enhance the detective interface
• Improve documentation

Check the Contributing Guidelines to join the force and help make SQL Noir even better.