OpenTrip Nusantara: Curated Travel Platform
Integrated Indonesian open-trip exploration and reservation ecosystem: Web Admin Portal for tour operators and Flutter Mobile App featuring interactive AI travel assistant recommendations.
Role-Isolated Ecosystem Previews
Centralized travel management portal: booking analytics dashboard, open-trip package catalog, customer transaction ledger, user & guide directory, and live supervision of chats and AI travel recommendations.
Project Architecture & Overview
OpenTrip Nusantara connects verified local tour operators with adventurers across Indonesia. Features a web admin portal for managing departure quotas, customer reservations, tour guide directories, and chat oversight. On the traveler side, the Flutter mobile app provides curated exploration feeds for premier destinations (Bromo, Labuan Bajo, Bali), interactive conversational AI itinerary advice, direct logistical messaging with tour leaders, and digital booking passes.
Case Study & Retrospective
Race Conditions on Last-Seat Booking
Two concurrent users clicking pay in the exact same millisecond caused overbooking on final tour slots.
Implemented PostgreSQL database transactions with row-level locking (SELECT ... FOR UPDATE) in Supabase stored procedures to guarantee atomic seat decrements.
High-Resolution Destination Gallery Image Optimization
4K destination photos from operators degraded LCP metrics to 4.9s on mobile browsers.
Configured Cloudflare Images & R2 pipeline for automated dynamic WebP/AVIF transformations tailored to client viewports.
