Campus Carpool - Ride Sharing Web Application

A web application for campus ride-sharing where drivers can offer rides and riders can request seats.

Tech Stack

User registration and login with secure session management
Browse all available rides without login required
View detailed ride information including driver, date, time, and available seats

Offer rides with origin, destination, date, time, seats available, and optional notes
Manage rides from a personal dashboard
Edit or cancel rides at any time
Review seat requests from riders
Approve or decline seat requests
Automatic notification system (console logs for development)

Riders automatically placed on waitlist when ride is full
Waitlist riders automatically promoted when:
- Driver increases available seats
- Driver declines an approved request
- Rider cancels an approved request
Mock email notifications sent to waitlisted riders when seats open up

npm install

npm start

The application will be available at port 5000.

The application uses MySQL (you can manage it with MySQL Workbench).

Quick setup:

Create a database (for example campus_carpool) and a user with appropriate privileges.
Import the SQL schema from database/schema.sql using MySQL Workbench (Server > Data Import) or the mysql command-line client:

mysql -u your_user -p campus_carpool < database/schema.sql

See database/schema.sql for the full schema.

Environment variables (use .env):

The application includes an intelligent automatic waitlist system:

When all seats are taken, new requests are automatically placed on a waitlist
When seats become available (through editing, cancellations, or declines), the oldest waitlisted rider is automatically promoted to "submitted" status
Mock email notifications are logged to the console when waitlisted riders are promoted