💥 🚢 USS QL 🚢 💥

USS QL is an interactive learning platform for users to practice SQL queries to reinforce SQL syntax in an engaging and entertaining format.

Installation

MacOS (Install dependencies)

% npm install

WindowsOS (Install dependencies)

$ npm install 

Usage

MacOS (Run dev server)

% npm run dev 

WindowsOS (Run dev server)

$ npm run dev 

Gameplay Instructions

1. Click "New Game" button.

2. Make SELECT query to make board selection

3. If enemy ship is at location, make UPDATE query to hit ship

   

4. If player has 'HELP' munitions (3 Turns), make INSERT query to deploy

   

NOTE: Each input made by user will be checked for the correct format/syntax

Iteration Roadmap

1. Dynamic gameboard:
   • Ability for user to scale gameboard size
2. Improve player input queryString read functionality:
   • Current state: user must use exact stylistic syntax (i.e. spaces)
   • Desired state: player input is interpreted, exact stylistic syntax not required
3. Multiplayer/AI:
   • 2 player mode
   • Enemy AI
4. User Authentication:
   • User would be able to keep track of score

Known Bugs

1. Player has ability to input SQL query before player prompt has fully rendered (async issue).
2. Using the 'HELP' feature and hitting the ship entirely does not render the 'game over' prompt.

Contact Info

Developed By
Josh Howard
William Lee
Brandon Tran
Chris Oakes