Can I vibe code Marsello?

Build an online-only loyalty and rewards REST API using Node.js, Express, and PostgreSQL. 1. DATA MODEL: Create tables for 'customers' (id, email, points_balance, current_tier), 'transactions' (id, customer_id, order_id, points_change, type ['earned', 'redeemed'], created_at), 'rewards' (id, title, points_cost, discount_code_prefix), and 'tiers' (id, name, min_spend, multiplier). 2. CORE LOGIC: Expose an endpoint POST /webhooks/orders-created to receive ecommerce store order payloads. Calculate earned points by multiplying dollar total by the customer's tier multiplier. Store this in transactions and update the points balance atomically using a database transaction to avoid race conditions. Create POST /rewards/claim endpoint which verifies points_balance >= points_cost, deducts points, generates a unique single-use coupon string, and records the redemption transaction. 3. CUSTOMER PORTAL: Provide a GET /customers/:id/loyalty endpoint returning their point balance, recent history, current tier, and progress toward the next tier. 4. FAILURE MODES: Reject duplicate order webhooks via order_id idempotency checks. Handle concurrent reward claims by using SQL row-level locking (SELECT FOR UPDATE) on the customer balance record. 5. OUT OF SCOPE: Do not build physical POS sync, email template design builders, or SMS gateway logic. Focus strictly on the online points engine.

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