Full-Stack Web·PROJECT_04
Full-Stack Travel Companion Platform
Domain
Full-Stack Web
Role
Full-Stack Engineer & DB Architect
Stack
React · Node.js · Express · PostgreSQL · REST APIs
Year
2026

Overview
TravelDost is a full-stack travel planning platform with 3NF normalized PostgreSQL schemas, multi-tier RESTful API routing, and a responsive React frontend for managing multi-destination itineraries.
React.jsNode.jsExpress.jsPostgreSQLTailwind CSSREST API
The Challenge
Standard travel tools rely on unstructured documents. The goal was engineering an atomic relational database with sub-50ms API lookups across travel companions.
System Architecture
Normalized PostgreSQL to 3NF atomic schemas. RESTful Express API routes with parameterized SQL queries. React frontend with custom state engine linking interactive maps to travel schedules.
Validation Metrics
Relational Schema
Strict 3NF Normalization
API Framework
RESTful Express.js
Query Execution
<45ms Indexed Queries
State Sync
Interactive Map & Schedule Engine
Key Highlights
Zero redundant data via strict 3NF normalization.
Sub-45ms SQL execution with indexing on trip lookup keys.
Interactive map state engine linked to step-by-step schedule.