
Hemoconnect Web Application
Healthcare and blood donation connection platform with high-reliability RESTful API endpoints and PostgreSQL schema design.
Timeline
2024
Role
Backend Developer
Team
Collaborative Engineering Team
Status
CompletedTechnology Stack
Key Challenges
- Urgent Blood Type Compatibility Logic
- Strict Data Privacy & Authentication
- Relational Database Indexing Under Load
- Transactional State Consistency
- Comprehensive API Error Boundary Handling
Key Learnings
- Advanced PostgreSQL Relational Design
- RESTful API Best Practices with Express.js
- Automated Postman Test Suite Execution
- Healthcare Data Security Guidelines
- Full-Stack Frontend-Backend Contract Design
Hemoconnect Web Application
Overview
Hemoconnect is a dedicated web platform designed to streamline and accelerate the critical process of connecting voluntary blood donors with patients, emergency responders, and hospital clinics in urgent need of transfusions.
In emergency healthcare situations, traditional communication methods (phone trees, broadcast text messages, social media posts) are slow, disorganized, and prone to misinformation. Hemoconnect provides a verified, structured platform that matches urgent blood donation requests with compatible, nearby donors within minutes.
As the Backend Developer on the project, I was responsible for designing the database models, developing the core RESTful API endpoints in Node.js and Express.js, and implementing rigorous data verification logic.
Architecture & System Design
The backend is built around a service-oriented architectural pattern emphasizing speed, data integrity, and strict input validation:
+-----------------------------------------------------------+
| Client Application (Web & Mobile) |
| - Hospital Emergency Request Submissions |
| - Donor Profile & Availability Management |
| - Real-time Transfusion Matching Alerts |
+-----------------------------------------------------------+
|
v (HTTPS / JSON REST API)
+-----------------------------------------------------------+
| Express.js Routing & Middleware |
| - JWT Token Authentication & Role Validation |
| - Rate Limiting & Input Sanitization Pipelines |
| - Error Handling & Structured HTTP Responses |
+-----------------------------------------------------------+
|
v
+-----------------------------------------------------------+
| Business Logic & Matching Engine |
| - Blood Compatibility Matrix Evaluation |
| - Urgency Tier Prioritization (Critical vs Standard) |
| - Geo-Radius Query Calculations |
+-----------------------------------------------------------+
|
v (pg Connection Pool)
+-----------------------------------------------------------+
| Database Layer (PostgreSQL) |
| - Verified Users & Donor Entities |
| - Blood Request Records with Partial Indexes |
| - Audit Logs & Fulfillment State Tracking |
+-----------------------------------------------------------+
Core Features & Functionality
1. Automated Compatibility Matching
Built-in algorithmic evaluation based on medical blood donation compatibility:
- O-Negative: Universal donor for all red blood cell transfusions.
- AB-Positive: Universal recipient for red blood cells.
- Compatibility checks occur programmatically before notifications are dispatched, eliminating incorrect donor matches.
2. Urgency Tier Management
Requests are categorized into distinct operational tiers:
- Critical (Code Red): Immediate life-threatening trauma cases given top ranking and instant push alerts.
- Urgent: Surgical operations scheduled within 24 hours.
- Standard: Routine hospital replenishment.
3. Verification & Security
- Strict role-based access control (RBAC) ensuring only verified medical personnel or validated users can initiate urgent blood calls.
- Personal donor contact details remain protected until a mutual match confirmation is acknowledged.
Database Architecture in PostgreSQL
The database schema was normalized to 3NF while utilizing selective indexed views for active requests:
-- Core matching entity tracking donor engagements
CREATE TABLE donor_matches (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
request_id UUID NOT NULL REFERENCES blood_requests(id) ON DELETE CASCADE,
donor_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
match_status VARCHAR(20) DEFAULT 'NOTIFIED'
CHECK (match_status IN ('NOTIFIED', 'ACCEPTED', 'DECLINED', 'COMPLETED')),
response_time TIMESTAMP WITH TIME ZONE,
created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
-- Fast lookup index for active matches
CREATE INDEX idx_donor_matches_status ON donor_matches (donor_id, match_status);
Quality Assurance & Testing
- Postman API Suites: Created automated test collections covering over 40 distinct endpoint scenarios (authentication failures, invalid payload schemas, concurrent donation pledges).
- Load Simulation: Tested high-volume batch requests to verify connection pool resilience and query execution speed.
Key Outcomes
- Eliminated Manual Bottlenecks: Automated match identification reduced average donor search turnaround from hours to minutes.
- Production-Grade Reliability: Zero unhandled exceptions recorded during end-to-end integration testing.
- Engineering Growth: Deepened expertise in relational database architecture, healthcare data security, and high-concurrency API design.