Technologies Used

Frontend Technologies

• HTML5

• CSS3

• JavaScript

• Bootstrap

• Responsive GenZ UI Design

The frontend technologies are used to create an attractive, responsive, and user-friendly interface for students, teachers, and admin users.

Backend Technologies

• Python

• Flask Framework

Python Flask is used for handling server-side logic, routing, authentication, database connectivity, request processing, and overall application functionality.

Database Technology

• MySQL

MySQL is used to store and manage:

• student records

• teacher records

• books data

• issued books

• renewal requests

• fines

• notifications

• question papers

• OTP records

Python Libraries Used

1. Flask-Mail

Used for:

• OTP email sending

• password reset emails

• reminder notifications

• credential emails

2. Pandas

Used for:

• reading Excel sheets

• processing bulk student data

• data handling during Excel import

3. OpenPyXL

Used for:

• handling .xlsx Excel files

• importing student records from Excel

4. Werkzeug Security

Used for:

• password hashing

• password verification

• secure authentication

5. Jinja2 Templates

Used for:

• dynamic HTML rendering

• passing backend data to frontend pages

6. Flask Sessions

Used for:

• login session management

• route protection

• authentication handling

Development Tools

• Visual Studio Code (VS Code)

• MySQL Workbench

• XAMPP / MySQL Server

• Ngrok (for external/mobile testing)

UI/UX Technologies

• Responsive Dashboard Design

• Glassmorphism UI

• Notification Badges

• Smooth Animations

• Interactive Cards

Security Technologies

• OTP Verification System

• Password Hashing

• Session-based Authentication

• Admin Approval Workflow

• Secure File Validation

File Handling Technologies

• PDF Upload System

• Image Upload System

• Excel File Import System

Communication Technologies

• Gmail SMTP Integration

• Email Notification System

• Automated Reminder Emails