SkillVault — Developer Learning Platform
Built an enterprise-grade developer learning platform with Spring Boot 4, Java 17, Next.js 16, and PostgreSQL, indexing 30+ engineering curriculums (LLD, HLD, System Design, GenAI) into a normalized relational schema via a Git-backed markdown content pipeline. Engineered a content indexing service that scans and upserts course/module/lesson hierarchies from disk into PostgreSQL, exposing REST APIs for catalog browsing, search, and progress tracking with sub-100ms response times via tuned HikariCP connection pooling, plus a custom cloud-database URL adapter supporting Neon/Render/Railway.
Tech Stack
Spring Boot 4Java 17Next.js 16React 19TypeScriptPostgreSQL (Neon)DockerHikariCPTailwind CSS
Key Features
- Git-Backed Content Pipeline: Scans and indexes 30+ engineering curriculums (LLD, HLD, System Design, GenAI) into a normalized relational PostgreSQL database schema.
- Content Indexing Service: Upserts course/module/lesson hierarchies dynamically from disk markdown into PostgreSQL.
- Sub-100ms REST APIs: Catalog browsing, search, and progress tracking with optimized JPA queries and tuned HikariCP connection pooling.
- Custom Cloud Database Adapter: Universal DataSourceConfig bean parsing Unix database URLs for serverless Neon, Render, and Railway PostgreSQL.
- Dual-Sidebar Reading Workspace: Hierarchical curriculum syllabus accordion, raw markdown reader, and real-time scroll timeline observer.
- Live Health & Telemetry Dashboard: Operational health probe monitoring JVM heap, database latency (3ms), and connection health.
Architecture & System Design
SkillVault Developer Dashboard & Metrics
