📦 ETrax - Technical Architecture
Modern SaaS platform for sports equipment inventory with QR tracking, voice commands, offline-first PWA, and FERPA/GDPR compliance.
System Architecture Overview
ETrax is a full-stack SaaS platform designed specifically for educational institutions managing sports equipment inventory. It combines a mobile-first Progressive Web App with a robust backend API, enabling real-time synchronization, QR code-based tracking, voice command support, and complete offline functionality for field operations.
┌──────────────────────────────────────────────────────────┐
│ PROGRESSIVE WEB APP (Frontend) │
├──────────────────────┬──────────────────────┬────────────┤
│ React Web UI │ Service Worker │ IndexedDB │
│ (Responsive) │ (Offline Support) │ (Local) │
└──────────────────────┴──────────────────────┴────────────┘
↓
┌──────────────────────────┐
│ Offline-First Sync │
│ Queue & Background Sync │
└──────────────────────────┘
↓
┌──────────────────────────────────────────────────────────┐
│ API GATEWAY & BACKEND SERVICES (Tier 2) │
├──────────────────────┬──────────────────────┬────────────┤
│ Express.js API │ WebSocket Gateway │ Auth │
│ RESTful endpoints │ Real-time updates │ Service │
└──────────────────────┴──────────────────────┴────────────┘
↓
┌──────────────────────────────────────────────────────────┐
│ BUSINESS LOGIC & PROCESSING (Tier 3) │
├──────────────────────┬──────────────────────┬────────────┤
│ Equipment Service │ QR Code Service │ Voice AI │
│ Inventory Mgmt │ Barcode generation │ Processing│
│ Reporting Service │ Label printing │ │
└──────────────────────┴──────────────────────┴────────────┘
↓
┌──────────────────────────────────────────────────────────┐
│ DATA & PERSISTENCE (Tier 4) │
├──────────────────────┬──────────────────────┬────────────┤
│ PostgreSQL 17 │ Redis Cache │ S3-like │
│ Relational data │ Session & cache │ QR images │
└──────────────────────┴──────────────────────┴────────────┘
Technology Stack
📱 Frontend (PWA)
- React 18+
- Vite 6
- TypeScript
- Tailwind CSS
- Service Workers
🔧 Backend
- Node.js 23.5+
- TypeScript
- Express.js
- Prisma ORM
- PostgreSQL 17.2
📦 QR & Barcode
- QR Code generation
- Barcode scanning (camera)
- Label printing APIs
- Thermal printer support
- Template engine
🎤 Voice Processing
- Web Speech API
- OpenAI Whisper
- NLP for commands
- Text-to-speech
- Custom model training
💾 Data & Cache
- PostgreSQL 17
- Prisma Migrations
- Redis 7.4
- IndexedDB (browser)
- Query caching
🧪 Testing & Ops
- Vitest (unit)
- Playwright (E2E)
- Supertest (API)
- Docker & Docker Compose
- PM2 (process management)
Core Features & Architecture
🏷️ QR Code Tracking
Automatic QR code generation, scanning via device camera, batch label printing, and equipment linking.
🎤 Voice Commands
Natural language processing for equipment check-in/out, inventory commands, hands-free operation in field.
📱 Offline-First PWA
Complete functionality offline, automatic background sync when reconnected, no app download required.
🔄 Real-time Sync
WebSocket-based synchronization, conflict resolution, and eventual consistency across devices.
📊 Analytics
Equipment usage trends, maintenance alerts, lifecycle cost analysis, and predictive replacement.
🏫 Multi-Tenant
Isolated school instances, hierarchical access control, bulk operations, and centralized reporting.
Compliance & Security
FERPA Compliance
- ✓Student directory excluded
- ✓Data encryption at rest
- ✓Access logging
- ✓Data deletion policies
GDPR Compliance
- ✓Data portability
- ✓Right to deletion
- ✓Privacy by design
- ✓DPA-compliant processors
Deployment & Performance
Performance Targets
- API Response: < 100ms
- QR Scan: < 500ms
- Sync Time: < 1s
- Offline Cache: 100+ records
Deployment Stack
- Frontend: Vercel / Netlify
- Backend: AWS EC2 / Heroku
- Database: AWS RDS / Cloud SQL
- CDN: Cloudflare / CloudFront