Refactor Backend Error Handling & Database Integrity

[navin-oss]

The backend currently exposes internal error details and lacks proper database constraints and transactional safety. This may lead to security leaks, orphaned records, and inconsistent classroom/member data.

---

Tasks

• Sanitize API error responses
• Hide stack traces in production
• Add centralized error handling utility
• Add foreign key constraints
• Add CASCADE DELETE support
• Wrap multi-step DB operations in transactions
• Add missing unique constraints

---

Files Involved

• configs/schema.ts
• configs/db.tsx
• lib/auth-utils.ts
• Classroom-related API routes

---

Labels

GSSoC26 backend database bug

---

Expected Outcome

• Improved backend security
• Better database integrity
• Reduced risk of orphaned records
• Consistent transactional behavior
• Cleaner and safer API responses

---

assign it to me

[navin-oss]

I m working on it

[HARISH-BN890]

Hi, I would like to work on this issue. Please assign it to me