TripYork
Multi-Source Travel Metasearch Engine
Client Context & Objectives
TripYork is a consumer travel metasearch engine allowing travelers to compare flight, hotel, and car rental prices across multiple global travel aggregators.
The Core Technical Challenge
Aggregating real-time rates from third-party travel providers requires rapid geolocation detection, high-speed cached queries, and resilient database indexing.
My Role & Architectural Approach
Role: Backend Engineer. Built geolocation resolution, search query indexing, and aggregator connectors.
Engineered sub-300ms search APIs with automatic user geolocation detection. Implemented database sharding and index optimization in PostgreSQL for instant pricing lookups.
Verified Results & Business Impact
- Sub-300ms API response times across multi-source travel search queries.
- Accurate geolocation routing via network and IP detection.
- Optimized database schema using targeted sharding and indexing.
Engineering Highlights
- Sub-300ms performant search REST APIs
- Network-based automatic geolocation and currency localization
- Database sharding and composite indexing for high query throughput
System Interface & Workflow Gallery
Click any screenshot to expand.
