DestinyTrail | Architectural Deep-Dive
AtlasPremier / DestinyTrail
A high-performance geospatial travel engine designed for real-time itinerary optimization and cross-platform synchronization.
> SYSTEM_SPECS
- ENGINE: .NET 10 Web API
- GEO_ENGINE: Google Maps SDK
- DATABASE: SQL Server (Spatial)
- MAPPING: Entity Framework Core
- AUTH: JWT + OAuth 2.0
01. Project Objectives
DestinyTrail was architected to bridge the gap between static travel planning and dynamic, real-time exploration. The primary challenge was handling massive datasets of points-of-interest (POIs) while maintaining sub-second latency for users on mobile devices.
02. Core Architectural Pillars
A. GEOSPATIAL DATA OPTIMIZATION
Leveraging SQL Server Spatial types, the system performs distance calculations and radius searches directly at the database level using `STDistance` logic, reducing the overhead on the application server.
B. ASYNCHRONOUS API INTEGRATION
The engine orchestrates data from multiple third-party vendors (Flights, Hotels, Local Events) using an **Asynchronous Request-Reply pattern**. This ensures that one slow external API doesn't hang the entire user experience.
Technical Implementation: Spatial Query
var nearbyLocations = await _context.Locations
.Where(l => l.Coordinates.Distance(userPoint) <= radius)
.OrderBy(l => l.Coordinates.Distance(userPoint))
.Take(25)
.ToListAsync();