Platform
Council of Personal Trainers (CoPT)
Migrated & Optimized Trainer Platform
1 / 3
Executive Summary
The Situation:CoPT had an existing trainer marketplace burdened by massive technical debt, expensive AWS overhead, and a sluggish user experience that hindered trainer signups.
The Mandate:Execute a zero-data-loss migration from AWS to Hostinger while simultaneously refactoring the entire Next.js codebase to eliminate performance bottlenecks and improve geolocation features.
The Result:Successfully migrated the platform, cut server hosting costs drastically, and delivered a highly optimized UK-wide map interface handling 100+ active trainers.
Architecture Stack
Next.js
React
Google Maps API
TypeScript
Database Migration
Hostinger
Real-time Location
Technical Deep-Dive
Overcoming Bottlenecks
Migrating a live, relational database between distinct cloud providers without causing downtime or losing active trainer profiles and booking data.
First-Principles Engineering
Executed a strategic multi-phase data migration strategy. I refactored the Next.js API routes to handle connection pooling more efficiently and implemented advanced Google Maps clustering to handle heavy geospatial data on the frontend without lagging.
Business Impact
Infrastructure Cost Reduction
Successfully transitioned architecture from expensive AWS tiers to an optimized Hostinger environment.
Enhanced User Experience
Map rendering times improved drastically, leading to higher retention rates for users searching for trainers.
Technical Debt Elimination
Refactored legacy code into modern, typed Next.js standards, future-proofing the platform.