Can I vibe code PushPushGo?

Build a self-hosted web push notification service to replace PushPushGo using Node.js, Express, PostgreSQL, Redis (BullMQ), and the official `web-push` npm library.

1. DATA MODEL & ARCHITECTURE:
- Create tables: `subscribers` (id, endpoint PRIMARY KEY, keys_p256dh, keys_auth, user_id, tags JSONB, store_id, created_at, updated_at), `campaigns` (id, title, body, icon, url, scheduled_at, status), `notifications_log` (id, subscriber_id, campaign_id, status, error_code, sent_at).
- Maintain VAPID public/private key pairs securely in environment variables.

2. FRONTEND CLIENT & SERVICE WORKER:
- Build a standalone JavaScript snippet to embed on the storefront (`push-client.js`) and a `sw.js` Service Worker file.
- Script logic: Check `Notification.permission`. If default, present a custom prompt modal. On accept, call `navigator.serviceWorker.ready` and `registration.pushManager.subscribe()` passing your VAPID public key.
- Send payload `{ endpoint, keys: { p256dh, auth }, tags: [...] }` to backend endpoint POST `/api/v1/subscribe`.
- Implement `sw.js` to listen for `push` events, parse JSON payload, and call `self.registration.showNotification(title, options)`. Listen for `notificationclick` events to open the designated `url` in a browser tab.

3. BACKEND API & PUSH DISPATCH ENGINE:
- POST `/api/v1/subscribe`: Save or update push token subscription object.
- POST `/api/v1/unsubscribe`: Delete subscription endpoint from database.
- POST `/api/v1/campaigns/send`: Accept push payload (title, body, icon, link, tag filter). Fetch matching subscribers in batches. Enqueue delivery jobs into BullMQ.
- BullMQ worker executes `webpush.sendNotification(subscription, payload)`. Handle failure responses: if HTTP status is 404 or 410 (Gone), automatically purge the invalid subscription from the PostgreSQL table.

4. ECOMMERCE TRIGGERS:
- Implement POST `/api/v1/webhooks/abandoned-cart` to schedule a delayed job (e.g. 2 hours). If cart remains unpurchased, fetch push token for matching `user_id` and send a push notification.

5. OUT OF SCOPE:
- Mobile native push (APNs/FCM native SDKs), visual Drag-and-Drop flow builder UI, multi-tenant billing logic.

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