Comprehensive Guide: Building Scalable E-commerce BackendsComprehensive Guide: Building Scalable E-commerce Backends
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Nichita's avatar
Nichita Costromin
• Jun 23
Just built a production ecommerce backend from scratch. Stateless auth, role-based permissions down to the button, real-time order tracking, and an admin panel that actually scales:
Stack:
Next.js (API routes + SSR), Prisma ORM, Neon Postgres (serverless driver, connection pooling), JWT auth, AWS S3.
🔒 Auth & permissions:
JWT with access/refresh token pair. Refresh rotation on every cycle. Access tokens are short-lived, never stored in localStorage. RBAC enforced at middleware. Roles are database entities, not hardcoded enums. Permissions are scoped to route + HTTP method + resource. A "manager" can edit products but can't touch user roles. An "operator" can update order status but can't delete inventory.
⌗ Data layer: Normalized Postgres schema. Orders, products, inventory, users, roles, and a dedicated order_status_history table. Every state transition is an insert, not an update. Full audit trail with timestamps and actor IDs.
🫙Storage: S3 with presigned URLs. Upload flow: client requests a signed URL from the API, uploads directly to S3, API stores the object key. No file ever passes through the server.
🏎️ Order tracking: Strict state machine. Pending > Confirmed > Processing > Shipped > Delivered. No state can be skipped. Cancellations branch from any pre-shipped state and trigger inventory rollback. Client polls for updates with optimistic rendering.
🛖 Infrastructure: Vercel for compute. Neon serverless for Postgres with edge-compatible driver. No persistent connection pool to manage. Scales to zero when idle, spins up in milliseconds.
Database DevelopmentAWSNext.jsPrismaBackend Development
Post image
Post image
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started