Fly Panner - Flexible Flight Search & Weekly Price Alerts
Fly Panner started from a real problem: I was planning a trip and needed to find the cheapest flights, but manually browsing each date one by one was exhausting — and coming back every day to re-check was even worse. I wanted a smarter way: set a departure and return date range, fire off all combinations at once, and get results ranked by price immediately. And when I found a good route, I didn't want to keep checking — I wanted it to just tell me every week. This project was built AI-first using Claude Code, which accelerated architecture decisions, API design, database schema, and the email pipeline. The app is built on Next.js 14 (App Router) with TypeScript, uses the Duffel Air API for real-time flight pricing, and Prisma with Neon PostgreSQL to persist subscriptions. Every Monday, a Vercel cron job triggers the alert pipeline — Resend delivers styled weekly digest emails to all active subscribers, each containing a secure one-click unsubscribe link. The search engine scans up to 50 date combinations concurrently, with results filterable to direct-only flights and sortable by price, departure date, duration, or stops. Results can also be exported to CSV for offline analysis.
- Flexible date range search — scans up to 50 departure and return date combinations concurrently
- Weekly email price alerts — subscribe once, receive best fares every Monday via Resend
- One-click secure unsubscribe link included in every alert email
- PostgreSQL (Neon serverless) + Prisma ORM for subscription persistence
- Vercel cron job triggers weekly alert pipeline automatically (Mondays at midnight UTC)
- Direct-only flight filter to show non-stop results exclusively
- One-way and round-trip itinerary support
- Results sortable by price, departure date, flight duration, or number of stops
- Airport autocomplete search for easy origin and destination input
- CSV export for offline flight comparison and analysis
- Built AI-first using Claude Code for architecture, API integration, and email pipeline design
Frontend
Backend
Database
AWS Services
Development Tools
- Migrating from Amadeus to Duffel Air API — adapting to a new authentication model and flight offer response schema
- Designing the weekly cron pipeline: Vercel cron → fetch best fares per subscription → batch Resend email delivery
- Generating secure, token-based one-click unsubscribe links without exposing user data
- Managing up to 50 concurrent Duffel API requests per search while keeping latency acceptable
- Setting up Prisma with Neon serverless PostgreSQL for both pooled and direct connections on Vercel
- Leveraging Claude Code to accelerate database schema design, API route architecture, and email template creation
- Duffel Air API — authentication, flight search endpoints, and offer response parsing
- Prisma 5 ORM with Neon serverless PostgreSQL — schema design, migrations, and connection pooling on Vercel
- End-to-end subscription pipeline: database storage → Vercel cron trigger → Resend batch email delivery
- Secure unsubscribe token generation and validation in a serverless environment
- AI-first development workflow with Claude Code — rapid prototyping, API integration, and pipeline design
- Vercel cron job configuration and deployment with protected secret headers
- Client-side CSV generation for data export without a dedicated backend endpoint