Django CRUD Application 🚀

This project is a Django-based CRUD application that integrates MySQL for the database and SQLAlchemy for object-relational mapping (ORM). It is designed to manage employees and departments efficiently while optimizing performance through Redis caching.

Key Features ✨

• Django Framework: The project is built using the powerful Django framework for the backend.
• MySQL Database: MySQL is used to store employee and department information.
• SQLAlchemy ORM: SQLAlchemy is used for smooth database management via ORM.
• Redis Caching: Redis caching improves performance for frequently queried data like employees and departments.
• JWT Authentication: JWT (JSON Web Tokens) are used for secure login and user authentication.
• Cerberus Validation: Input data is validated using Cerberus to ensure data integrity during department and employee management.
• REST API: The application exposes multiple API endpoints for:
  • CRUD operations on employees and departments.
  • Ordering employees by salary.
  • Pagination and offset support for efficient data fetching.

Technologies Used 💻

• Django: Web framework for the backend.
• MySQL: Database for storing data.
• SQLAlchemy: ORM for database management.
• Redis: Caching system to optimize performance.
• JWT: Secure authentication method for users.
• Cerberus: Input validation library.
• Django REST Framework (DRF): Framework for building REST APIs.

Setup Instructions 🛠

1. Install Dependencies: Ensure MySQL, Redis, and Django are installed and set up.
2. Run Migrations: Set up the MySQL database and apply migrations using Django commands.
3. Start the Application: Run the development server using Django's default server.

Demo 🛠

https://www.awesomescreenshot.com/video/36887544?key=c74c0675f47003c3daed2bbce934e71d

ScreenShots 📸

Home Screen

JWT Login

Department Table

API Deparetmentlist

Employee Table