JobApp
An AI-powered job application tracker for managing applications, resumes, and job search insights.
Technologies Used
TypeScriptReactTanStack StartTanStack RouterTanStack QueryTanStack TablePostgreSQLDrizzleZodClerkGemini AITailwind CSSshadcn/uiBase UIdnd-kitFlexSearchRecharts
Timeline
Aug 2026 - Aug 2026Co-Authors
This project was completed individuallyNo video available
Key Accomplishments
- Developed a full-stack job application tracking system with TanStack Start, React, PostgreSQL, and Drizzle, supporting application management across table and drag-and-drop Kanban views.
- Integrated Gemini AI to extract structured job metadata from user-provided job descriptions and generate on-demand resume-to-job fit analysis reports.
- Designed PostgreSQL data models with Drizzle for applications, resumes, notes, links, and related job-search data, including relationships and indexes for query optimization.
- Implemented PDF resume uploads with server-side text extraction, storing extracted resume content as text for use in AI-assisted job analysis.
- Built application search and filtering with FlexSearch, including filtering by application status and interest rating.
- Developed an analytics dashboard with Recharts to visualize key application statistics, activity, and pipeline distribution.
- Integrated Clerk for user authentication and protected application data, with server-side validation using Zod.
- Implemented CSV and JSON export of application data using native browser APIs.
- Leveraged TanStack Query and TanStack Table for server-state management and interactive application data views.
- Leveraged spec-driven development with OpenSpec to define feature requirements, acceptance criteria, and implementation tasks before development.