Can I vibe code Trustindex?

Build a self-hosted review aggregation backend and embeddable frontend widget to replace Trustindex for an e-commerce store.

1. DATA MODEL & BACKEND (Node.js/Express or Cloudflare Workers + SQLite/Supabase):
- Create a 'reviews' table: id, source (google, internal), external_id, author_name, author_avatar, rating (1-5), text, created_at, approved (boolean).
- Create a scheduled background job (cron) that runs daily to fetch reviews from the Google Places API (using Place Details API). Parse response, filter for ratings >= 4, upscale/save images locally, and upsert records into the database based on external_id.

2. API ENDPOINTS:
- GET /api/v1/reviews: Accepts params (min_rating, limit, page). Returns cached JSON array of reviews along with computed stats (average_rating, total_count).
- POST /api/v1/reviews: Internal endpoint to manually submit or import store reviews.

3. FRONTEND WIDGET (Vanilla JavaScript Web Component / Tailwind):
- Build a single, zero-dependency embed script (<script src=".../widget.js" data-store-id="123"></script>).
- The script fetches /api/v1/reviews asynchronously, then builds and mounts a responsive slider widget and summary badge ('Rated 4.9/5 based on X reviews').
- Ensure the widget is accessible, keyboard navigable, lazy-loads avatar images, and does not block DOM rendering.
- Dynamically append JSON-LD Schema.org AggregateRating markup to the document <head>.

4. EDGE CASES & ERROR HANDLING:
- Cache API responses at the edge or Redis layer with a 24-hour TTL to prevent exceeding Google API quotas.
- Gracefully fall back to local database records if the third-party API returns an error or rate limit.
- Sanitize all HTML and review text inputs before rendering to prevent XSS attacks.

5. OUT OF SCOPE:
- Admin dashboard UI (use basic DB management or Supabase studio for manual moderation).
- Scraping platforms that lack official APIs.

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