/en/work/agora
AGORA: Voix & Décisions
A citizen participation platform for UEH-CHCL, with UNDP, where Haitians propose, discuss and follow public decisions in three languages.
Problem
Citizens had no transparent way to submit proposals for their commune and see them followed through to a published decision. The platform had to work on phones, in English, French and Haitian Creole, and be trusted by an institution and a UN partner.
What I built
- A Laravel API-only backend and a Next.js frontend, with MariaDB and Sanctum sessions, deployed as two independent services.
- Propositions with a public status pipeline, comments, votes and surveys; reading is open to everyone, taking part needs a verified account.
- A map of Haiti with 10 départements, 140 communes and 570 communal sections, and a location picker on the submission form.
- Dashboards and reports for decision-makers and researchers, user manuals per role, and web analytics with self-hosted Umami.
- A staging runbook as one script (scripts/staging-deploy) with port checks, a verified backup and certificates.
Hard problems
- Making the whole interface and the backend validation messages trilingual (English, French, Haitian Creole).
- Load tuning: after a staging load test, the hot spots (96 % of database time) were fixed with grouped queries and caching, and the server was sized from the test.
- Privacy by design: retention rules for notifications, guest survey IPs and contact messages, and a public privacy page.
Security
Authenticated OWASP ZAP scans of the API as admin and as citizen, plus Trivy and dependency audits, each followed by fixes. Traefik with Let's Encrypt and HSTS, CrowdSec, per-account throttles, and every error returned as JSON.