Job application tracker

A kanban board for job applications with notes, contacts, reminders and a weekly summary.

Why build it

Relational modelling, filters and reminders: the same patterns as most business CRUD apps, and you are the first real user.

Features

• Kanban columns by stage
• Company, role, salary range, notes
• Contacts linked to applications
• Reminder emails for follow-ups
• CSV export

Roadmap

1. p1

   Schema

   • Model applications, companies, contacts and events
   • Write migrations
   • Seed realistic data
2. p2

   Board

   • Kanban UI with optimistic updates
   • Detail drawer with notes
   • Filters and search
3. p3

   Reminders

   • Scheduled job to find overdue follow-ups
   • Send email with Resend
   • Unsubscribe link
4. p4

   Quality

   • Integration tests for the stage-change logic
   • CSV export
   • Deploy with a managed Postgres

Common pitfalls

• Storing stage as free text instead of an enum
• Optimistic updates with no rollback on failure

Skills you will practise

• Relational design
• Migrations
• Background jobs
• Optimistic UI