The engine behind the Cedarrise Initiative’s mission — a comprehensive backend powering program management for after-school education, scholarships, capacity building, community outreach, and volunteer coordination across Nigeria. It handles everything from student registration and tracking to donation processing and automated notifications, all served through a secure API.
-
Multi‑Program Management
Manage ASH, TACOTS, Capacity Building, Outreaches, and Volunteer programs through dedicated form submissions, detailed record views, and CSV exports. -
Authentication & Role‑Based Access
Cookie‑based JWT authentication with silent token refresh. Three roles (Volunteer, Admin, SuperAdmin) with fine‑grained permissions control every operation.
sequenceDiagram
actor User
participant API as Backend API
participant DB as Database
User->>API: Send login credentials
API->>API: Validate email and password
API->>DB: Find user by email
DB-->>API: Return user record
API->>API: Verify password hash
API->>API: Generate access & refresh tokens
API->>User: Set HttpOnly cookies + profile
- Automated Notification System
A weekly BullMQ cron job scans for at‑risk students (dropout risk, low attendance, score drops) and inactive volunteers, then generates dashboard notifications that can be dismissed or auto‑resolved.
sequenceDiagram
participant Scheduler as BullMQ Scheduler
participant Worker as Notification Worker
participant DB as Database
Scheduler->>Worker: Trigger weekly check (Sunday 6 PM)
Worker->>DB: Run dropout risk queries
DB-->>Worker: Return at-risk students
Worker->>DB: Insert/update notifications
Worker->>DB: Auto-resolve stale notifications
- Donation Processing
Integrates with Paystack to initialize transactions, verify payments, and persist donor records. Thank‑you emails and internal alerts are fired automatically on success.
sequenceDiagram
actor Donor
participant API as Backend API
participant Paystack as Paystack
Donor->>API: Initialize donation (amount, email)
API->>Paystack: Create transaction
Paystack-->>API: Authorization URL
API->>Donor: Redirect to pay
Paystack->>API: Webhook / callback verification
API->>API: Persist donor & fire events
-
Analytics Dashboard
Pre‑computed metrics (cards, charts, geographical distributions) are cached and served for the admin dashboard, giving instant visibility into enrollment, performance, community service hours, and more. -
File & Photo Management
Upload passport photos, term results, receipts, gallery images, and blog documents to Cloudinary. Assets are organized by program and deleted via a BullMQ queue when records are removed. -
Rich Search & CSV Downloads
Every record list supports full‑text PostgreSQL search (weighted tsvector) and can be exported as a CSV file for offline analysis.
flowchart LR
Client["Dashboard / Website"]
API["Express API Server"]
Postgres[("PostgreSQL")]
Redis[("Redis")]
Cloudinary["Cloudinary Storage"]
Paystack["Paystack"]
Brevo["Brevo Email"]
Client --> API
API --> Postgres
API --> Redis
API --> Cloudinary
API --> Paystack
API --> Brevo
style Client fill:#1e1b4b,stroke:#6366f1,stroke-width:2px,color:#fff
style API fill:#2e1065,stroke:#8b5cf6,stroke-width:2px,color:#fff
style Postgres fill:#0f172a,stroke:#3b82f6,stroke-width:2px,color:#fff
style Redis fill:#4c0519,stroke:#ef4444,stroke-width:2px,color:#fff
style Cloudinary fill:#022c22,stroke:#10b981,stroke-width:2px,color:#fff
style Paystack fill:#451a03,stroke:#f59e0b,stroke-width:2px,color:#fff
style Brevo fill:#451a03,stroke:#f59e0b,stroke-width:2px,color:#fff
- Node.js 24+ and
pnpm - Docker and Docker Compose
-
Clone the repository and install dependencies:
git clone https://github.com/cedarrise-organization/backend.git cd backend pnpm install -
Create a
.envfile from the provided example and fill in your credentials (PostgreSQL, Redis, Cloudinary, Paystack, Brevo, etc.). -
Start PostgreSQL and Redis using Docker:
docker compose up -d cedarrise-postgres-db cedarrise-redis
-
Run database migrations and seed:
pnpm db:push pnpm db:seed # optional initial data -
Start the development server:
pnpm dev
The API will be available at
http://localhost:3000/api/v1.
All protected endpoints require the cedaraccess HTTP‑only cookie set after a successful login. Use the following credentials for testing after seeding:
curl -X POST http://localhost:3000/api/v1/auth/login \
-H "Content-Type: application/x-www-form-urlencoded" \
-d "email=admin@example.com&password=12345678" \
-c cookies.txtSubsequent requests will automatically include the cookie if using -b cookies.txt.
Fetch Dashboard Cards
curl http://localhost:3000/api/v1/dashboard/cards -b cookies.txtList ASH Students (paginated and filtered)
curl "http://localhost:3000/api/v1/forms/ash/registration?page=1&limit=25&status=pending" -b cookies.txtDownload Receipts CSV
curl -OJ http://localhost:3000/api/v1/general/download/receipts -b cookies.txtFull API documentation is available in the Bruno collection — a collection of interactive HTTP requests that mirror every endpoint and its expected payload.
| Technology | Purpose | Link |
|---|---|---|
| Node.js | Runtime | https://nodejs.org |
| Express | HTTP framework | https://expressjs.com |
| TypeScript | Language | https://www.typescriptlang.org |
| PostgreSQL | Primary database | https://www.postgresql.org |
| Drizzle ORM | Database toolkit | https://orm.drizzle.team |
| Redis | Caching & queue backend | https://redis.io |
| BullMQ | Job queues | https://bullmq.io |
| Zod | Schema validation | https://zod.dev |
| JSON Web Token | Authentication | https://jwt.io |
| Cloudinary | File uploads / CDN | https://cloudinary.com |
| Brevo | Transactional email | https://www.brevo.com |
| Paystack | Payment processing | https://paystack.com |
| EJS | Email templating | https://ejs.co |
| json2csv | CSV export | https://github.com/zemirco/json2csv |
| Docker | Containerisation | https://www.docker.com |
- LinkedIn: https://linkedin.com/in/Maxmillian%20Ogbuabor
- X (Twitter): https://x.com/KolbeTM
