Backend for Scalable Business Platform

Замовник: AI | Опубліковано: 04.03.2026

I already have a working web front-end, but the data layer behind it is still a proof-of-concept. I now need a production-ready Supabase backend that can confidently power inventory, CRM, marketing, and document-filing features at scale—and, where the current React code shows strain, you will refactor it so the whole stack remains clean, testable, and easy to extend. What the backend must cover • Inventory Management: robust stock tracking and supplier management tables, triggers, and Row-Level Security so every quantity change is auditable. • CRM: lead tracking, customer segmentation, and performance analytics views that can grow into millions of records without manual tuning. • Document Filing: storage buckets with signed-URL access, versioning, and metadata indexing. • API Integration: well-documented REST and, where helpful, RPC or GraphQL endpoints so external services can push or pull data safely. The current UI is in TypeScript/React; I’ll rely on you to adjust queries, state handling, and caching only where the move to Supabase’s Postgres, Edge Functions, and Realtime requires it. No redesign, just pragmatic refactors for scalability and maintainability. Deliverables 1. Supabase project schema (SQL migrations, seed data, RLS policies). 2. Edge Functions or server code for complex workflows (e.g., reorder thresholds, lead-score calculation). 3. Typed API layer consumed by the front-end, with OpenAPI docs autogenerated. 4. Updated front-end components that compile cleanly and pass existing tests. 5. A one-click deployment workflow (GitHub Actions preferred) and concise hand-off documentation. Acceptance criteria: all endpoints meet agreed response shapes, unit tests exceed 85 % coverage, and the demo workspace handles a simulated load of 10k concurrent users without data integrity issues.