This project is a Node.js + Express API designed as the backend of a lightweight CRM & campaign manager.
It ingests leads, cleans and deduplicates them, and powers email-based outreach campaigns with tracking and scalability in mind.

🚀 Features
Lead Ingestion

REST endpoint to receive new leads (validated & deduplicated before persistence).
Backed by PostgreSQL (via Supabase).
Campaign Management

Queue-based mail sending (Redis + Bull).
Integration with external mail providers instead of raw SMTP.
Tracks delivery, open rates, and click-through via webhooks & tracking pixels.
Job Processing

Dedicated worker processes handle heavy lifting (mail sending, validation).
Bullboard for monitoring job queues & statuses.
Authentication & Security

Supabase for user & org auth.
Optional 2FA.
Access tokens issued via JWT.
Scalability & Reliability

Queue workers independently scalable.
Redis for pub/sub + delayed retries.
🏗 Architecture
Express enqueues jobs via Bull.
Redis stores job data (waiting, active, completed, failed).
Workers (separate processes) pick up jobs and process them.
Jobs are guaranteed at-least-once delivery (may retry on failure).
You must design tasks to be idempotent (safe if retried).
±--------+ ±----------+ ±------+ ±----------+
| Client | ----> | Express | ----> | Bull | ----> | Redis |
±--------+ ±----------+ ±------+ ±----------+
|
v
±---------+
| Worker |
±---------+
|
v
±------------+
| Side Effect |
| (e.g email) |
±------------+
⚡ Tech Stack
Node.js + Express – REST API
Supabase – PostgreSQL + Auth
Redis – Queue backend
Bull – Job scheduling & retries
Bullboard – Job monitoring
External Mail Provider – Reliable email delivery & tracking

A comprehensive application that provides healthcare professionals with critical information on medication stability post-reconstitution, preparation guidelines, administration routes, and alerting notes. The application also includes a system for the Quality Control (QC) department to update and maintain data, ensuring that nursing staff have access to the most current information