CaseTrace App - Accelerate Discovery. Ensure Compliance.

• 

📝 CaseTrace App

Accelerate Discovery. Ensure Compliance.

Inspiration

Across Nigeria and similar governance environments, public funds rarely disappear because laws are missing. They disappear because oversight is fragmented, evidence is poorly structured, and accountability processes break down long before formal enforcement begins. Investigative teams, civil society organizations, journalists, and internal compliance units often rely on scattered emails, spreadsheets, and informal reports, making cases slow, fragile, and difficult to escalate.

CaseTrace was inspired by this systemic gap. The need is not louder accusations, but stronger structure. Not parallel justice, but reliable preparation for due process. CaseTrace addresses this by providing a centralized, traceable framework where governance and compliance issues can be documented clearly and preserved before escalation.

What It Does

CaseTrace is a legal accountability and governance case management platform designed to sit before enforcement, not replace it.

It structures potential compliance, procurement, and governance issues into traceable cases that preserve evidence, clarify responsibility, and support due process. By doing so, it creates a shared factual base that regulators, journalists, and civil society organizations can rely on before escalation to institutions such as the Economic and Financial Crimes Commission (EFCC) and the Independent Corrupt Practices and Other Related Offences Commission (ICPC).

Key capabilities include:

Centralized case visibility A real-time dashboard presents all active cases in one place, showing status, priority, and progress to eliminate information silos.

Structured case intake New cases are logged through a focused form that captures essential details consistently, reducing ambiguity and information loss at the earliest stage.

Built-in accountability Authenticated users ensure every case is created, owned, and acted upon by identifiable individuals, creating a clear audit trail.

Evidence-ready records Case histories, assignments, and updates are preserved in a structured format suitable for escalation, review, and long-term governance analysis.

CaseTrace transforms informal concerns into legally coherent case records, strengthening the upstream foundation of accountability.

How We Built It

We adopted a UX-first approach and implemented a scalable three-tier architecture focused on clarity, reliability, and legal defensibility.

Frontend

Built with React and TypeScript to ensure a predictable, type-safe interface

Styled using Tailwind CSS for a clean, responsive user experience

Emphasis on seamless frontend–backend integration to maintain data integrity across workflows

Backend

Developed with Node.js and Express using TypeScript

Handles authentication, routing, and core business logic

Designed to enforce consistent case structure and access control

Database and Data Layer

PostgreSQL as the primary database

Prisma ORM for schema definition, migrations, and safe database access

Controlled migrations ensured data consistency and future extensibility

The development cycle focused on full-stack integration, from schema design to real-time dashboard updates.

Challenges We Ran Into

Backend–frontend synchronization Early issues included connection failures and server errors caused by misconfigured API endpoints and missing database migrations. These were resolved through strict environment validation and enforced migration workflows.

Reliable data seeding and authentication Ensuring admin user creation and login flows were consistent required idempotent seeding logic and careful handling of authentication edge cases.

Accomplishments We’re Proud Of

A fully functional, type-safe API supporting secure authentication and case management

A complete end-to-end flow where cases move seamlessly from intake to persistent storage and instant dashboard visibility

A solid architectural foundation suitable for expansion into a full governance and compliance platform

What We Learned

Integrated debugging Tracing issues across HTTP layers, authentication logic, and database queries in a real-world full-stack system.

Security and best practices The importance of proper access control, environment configuration, migration discipline, and audit-ready data structures.

What’s Next for CaseTrace

Case detail views Dedicated pages showing full case information, history, and actions.

Activity logs and commenting Time-ordered records and collaborative discussion to strengthen evidence trails.

Case assignment and escalation workflows Assigning responsibility and preparing cases for formal review by oversight institutions.

Built With

Languages: TypeScript

Frontend: React, Tailwind CSS

Backend: Node.js, Express

Database: PostgreSQL

ORM: Prisma

Authentication: JSON Web Tokens (JWT)

Built With

• css
• dotenv
• express.js
• node.js
• postgresql
• prisma
• react
• tailwind
• typescript