Hugo Ribaud

Problem Statement

International camps managed everything on paper and Excel: restaurant menus, event programs, emergency contacts, announcements. Each new site required weeks of configuration. Residents constantly harassed the front desk for basic information, and low-connectivity areas made traditional cloud solutions unusable.

Technical Approach

• Multi-tenant architecture enabling new site deployment in less than a day with full customization
• React Native/Expo mobile app with offline-first support for limited connectivity areas
• Next.js web CMS allowing non-technical teams to manage content autonomously
• Supabase real-time synchronization for urgent announcements and updates
• Push notification system for instant communication with residents
• Robust REST API with offline sync conflict management
• Infrastructure deployed on Vercel with Supabase PostgreSQL database

Technologies Used

Key Learnings

• Well-designed multi-tenant architecture from the start enables massive scalability without rewriting
• Offline-first mode is crucial for field applications - connectivity should never be assumed
• An intuitive CMS drastically reduces support requests and empowers teams
• Managing a solo project of this scale requires rigorous discipline and modular architecture
• Real-world testing (isolated camps) reveals edge cases impossible to anticipate in development

Problem Statement

The association was running on an aging Java/Spring Boot 2.7 + Vue.js legacy system that was expensive to maintain and limited in features. They needed a modern ecosystem covering their various activities (mediation, training, debate) with reliable and cost-effective infrastructure.

Technical Approach

• Complete migration from Java/Spring Boot 2.7 + Vue.js to Next.js 16 + Supabase in 7 phases / 2 days
• Multi-application architecture: Argumenter (business app), Logos (toolbox), Réfléchir (debate roulette), Website (showcase)
• Self-hosted VPS infrastructure: 11 Docker containers orchestrated with Caddy and Kong
• Self-hosted multi-tenant Supabase with PostgreSQL 15 and Row-Level Security
• Automated monitoring: Beszel, Uptime Kuma, Sentry, 13 healthcheck and backup cron jobs
• Real-time alerts via ntfy for incidents and backups
• CI/CD with GitHub Actions and Vercel deployment for front-end apps

Technologies Used

Key Learnings

• Migrating a Java/Spring Boot monolith to Next.js + Supabase is achievable in a few days with rigorous phase-based planning
• Self-hosted multi-tenant Supabase requires careful Kong and GoTrue configuration for data isolation
• Automated monitoring (13 cron jobs) is essential for reliable self-hosted infrastructure
• Caddy greatly simplifies TLS/HTTPS management compared to Traefik for small infrastructures
• A 4-app ecosystem can run for ~€13/month on a well-configured VPS

Problem Statement

The client managed their 255 reflection questions in a Google Sheets file, which was difficult to use during sessions with participants. A modern web interface was needed to browse questions by category, project them in live mode during training sessions, with a robust database replacing Google Sheets.

Technical Approach

• React 19 architecture with TypeScript and Vite for type-safe, performant development
• Migration from Google Sheets to Supabase PostgreSQL for a robust database
• 16 question categories (255 topics) with intuitive navigation and search
• Live streaming mode for projection during training sessions
• Admin dashboard for content management and tracking
• Responsive design with Tailwind CSS v4 and Motion animations
• Deployment on Vercel with custom subdomain

Technologies Used

Key Learnings

• Migrating from Google Sheets to Supabase PostgreSQL improves reliability and performance for structured data
• Supabase offers excellent DX for rapid migrations with its dashboard and auto-generated APIs
• Live streaming mode requires fine-grained state and animation transition management
• Transforming an existing client tool (Sheets) into a web app reduces the adoption curve to zero