Can I vibe code AWeber?

Build a self-hosted email marketing and sequence automation microservice using Next.js (App Router), PostgreSQL, Prisma, and the Resend API.

1. DATA MODEL:
- Customer: id, email, firstName, status (subscribed, unsubscribed, bounced), createdAt
- Tag: id, name
- CustomerTag: customerId, tagId
- Sequence: id, name, active
- SequenceStep: id, sequenceId, delayDays, subject, bodyTemplate (HTML/Markdown)
- ExecutionLog: id, customerId, sequenceStepId, sentAt, status, resendMessageId

2. CORE FUNCTIONALITY:
- Public API endpoint (`POST /api/subscribe`) to accept double opt-in subscriptions.
- Webhook endpoint (`POST /api/webhooks/store`) accepting order events to automatically create/update customers and attach tags (e.g., 'purchased-item-x').
- Cron worker route (`/api/cron/process-sequences`) running every hour to scan for customers matching sequence delays who haven't received the step yet, sending emails via Resend SDK.
- Public unsubscribe handler (`GET /unsubscribe?token=...`) that updates customer status immediately and logs the audit trail.
- Dashboard UI showing subscriber counts, tag breakdowns, recent sequence dispatches, and bounce rates.

3. FAILURE MODES TO HANDLE:
- Resend API rate limits: Implemented exponentially backed-off job queues (using BullMQ or Redis) for bulk dispatches.
- Bounce & Complaint Webhooks: Implement `POST /api/webhooks/resend` to capture bounce or spam events and immediately flip customer status to 'bounced' to prevent further sending attempts.
- Duplicate Email Prevention: Ensure strict database uniqueness constraints on sequence execution logs per step per subscriber.

4. OUT OF SCOPE:
- Drag-and-drop visual template editors (use plain HTML or Markdown rendering).
- Built-in SMTP server hosting (rely strictly on third-party API providers like Resend or Postmark).

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs