Skip to content

README.md

Latest commit

 

History

History
40 lines (28 loc) · 1.6 KB

README.md

File metadata and controls

40 lines (28 loc) · 1.6 KB

Task_Management

🚀 Multi-Database Task Management System (Spring Boot + GraphQL + React)

A high-performance, real-time Task Management System designed to scale across 10 MySQL databases, supporting lakhs of tasks with optimized querying, Redis caching, and a responsive frontend using React + Apollo Client + MUI DataGrid.

📌 Features

✅ Backend (Spring Boot + GraphQL)

  • 🔗 Connects to 10 separate MySQL databases, each with unique task entities (Task to Task10).
  • ⚡ Handles lakhs of records efficiently using pagination, lazy loading, and batch fetching.
  • 🧩 GraphQL support with optimized resolvers for querying and subscriptions.
  • 🧮 getTotalTasksCount endpoint to aggregate task counts across all sources.
  • 🧠 Redis caching with TTL to reduce DB load and improve response times.
  • 🔁 Real-time updates via GraphQL subscriptions.

✅ Frontend (React + Apollo Client + MUI)

  • ⚛️ Built using React + Apollo Client for seamless GraphQL integration.
  • 📋 Uses Material-UI DataGrid with support for:
    • Server-side pagination
    • Sorting & Filtering
    • Auto-refresh for real-time experience
  • 🔄 Fetches and merges paginated task data from multiple sources for a unified view.

🛠️ Tech Stack

Layer Technology
Backend Spring Boot, GraphQL, Redis
Database MySQL (10 separate databases)
Frontend React, Apollo Client, MUI DataGrid
Caching Redis with TTL