Description
We need a REST API backend for our warehouse inventory system. It will serve as the data layer for our internal apps — a focused MVP with core CRUD, media handling, and access control, not a complex microservices architecture. Features Product endpoints: list with pagination, search/filter by name and category Product detail returning full record with associated media URLs Create/update products and adjust inventory quantities Media upload handling (photos/short videos) with storage integration (local or S3) Role-based access: admin and warehouse staff with different permissions Audit log tracking all quantity changes (who/when/old→new) Data Products organized by categories and items (warehouse → boxes → items). Relational schema with foreign keys and indexes for search performance. Endpoints (~10–14) Product CRUD, quantity update, media upload, categories, auth/token, users/roles, and audit history — documented via OpenAPI/Swagger. Integration Exposes a documented API that our Android and web clients consume. Reads/writes must persist to the database and reflect in real time. We'll provide DB access or define the schema together. Tech Your preferred stack (Node.js/Express, Python/FastAPI, or Go — open to discussion). PostgreSQL or MySQL. JWT auth with roles. Clean, documented code — reliability over feature bloat. Basic tests and deployment instructions required.