Interview Preparation Project

This project is designed to help candidates prepare for interviews by managing subjects and questions effectively. It includes functionalities to add subjects, manage questions, and retrieve random questions for practice. Built using Node.js, Express, and PostgreSQL, this project demonstrates robust backend development with RESTful APIs.

Features

• Add and manage interview subjects.
• CRUD operations for interview questions.
• Fetch questions by subject or randomly.
• Status management for questions (e.g., pending, completed).
• Uses PostgreSQL for database storage with secure connection configurations.
• Integration with environment variables for sensitive data handling.

Tech Stack

• Backend: Node.js, Express.js
• Database: PostgreSQL
• Frontend: HTML, CSS, JavaScript
• Deployment Ready: Configured for environment variables and SSL-secured PostgreSQL connections.

Installation

1. Clone the repository:

   git clone https://github.com/HariPasapuleti/PrepInt.git
   cd PrepInt

2. Install dependencies:

   npm install

3. Configure environment variables: Create a .env file in the root directory with the following details:

   DB_USER=your_username
   DB_PASSWORD=your_password
   DB_HOST=your_host
   DB_PORT=your_port
   DB_NAME=your_database
   

4. Start the server:

   npm start // npm server.js

   The server will run on http://localhost:3000 by default.

Database Configuration

The PostgreSQL configuration is stored in the pgConnect.json file. Adjust the settings as per your database setup.

Acknowledgments

This project was developed as part of interview preparation efforts to showcase skills in backend development, database management, and API design.