React + Vite

This template provides a minimal setup to get React working in Vite with HMR and some ESLint rules.

Currently, two official plugins are available:

@vitejs/plugin-react uses Babel for Fast Refresh
@vitejs/plugin-react-swc uses SWC for Fast Refresh

Built with

Development

To get a local copy of the code, clone it using git:

git clone https://github.com/viktor0556/quiz-game.git

Install dependencies:

npm install

Database setup: The application uses PostgreSQL for database management. Make sure you have PostgreSQL installed on your system and create a database for the project.

PostgreSQL initialization and database creation

Download: https://www.postgresql.org/download/
Create a database: Open a PostgreSQL service such as pgAdmin or psql. Log in with the appropriate user and then create a new database for the project.
Create tables: After you have created the database, create tables to store the necessary data. The following example shows how to create a simple question table:

CREATE TABLE questions (
    id SERIAL PRIMARY KEY,
    question TEXT NOT NULL,
    category TEXT NOT NULL,
    difficulty TEXT NOT NULL,
    answers JSONB NOT NULL
);

Setting environment variables: After you have created the database and tables, don't forget to set the project environment variables so that the application can connect to the database. For example:

DB_NAME=DB_NAME
DB_USER=DB_USER
DB_PASSWORD=DB_PASSWORD
DB_HOST=DB_HOST

These variables are usually stored in the .env file and must be set in the appropriate location to use them in the project.

Now, you can start a local web server by running:

cd frontend/ npm run dev

cd quiz-backend/ node server.js

And then open http://localhost:5173/ to view it in the browser.