Students Management API

A simple RESTful API built with Node.js, Express.js, and PostgreSQL to demonstrate backend development fundamentals.

Features

• Create a student
• Retrieve all students
• Update student information
• Delete a student
• PostgreSQL database integration
• Environment variables using .env
• Tested using Postman

Tech Stack

• Node.js
• Express.js
• PostgreSQL
• pg
• dotenv
• Body-Parser

API Endpoints

Method	Endpoint	Description
POST	/create	Create a new student
GET	/	Retrieve all students
POST	/edit	Update a student's age
POST	/delete	Delete a student

Installation

git clone https://github.com/CharafMC-1/Students_Management_API.git
cd Students_Management_API
npm install

Create a .env file:

DB_USER=your_username
DB_HOST=localhost
DB_DATABASE=your_database
DB_PASSWORD=your_password
DB_PORT=postegresPort

Run the server:

nodemon index.js

The server will start on:

http://localhost:3000

Testing

All endpoints were tested using Postman.

Author

Mohammad C.Charaf

Computer & Communication Engineer