Skip to main content
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
TravelDost project cover

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.