Spar Tech Labs Logo
Spar Tech Labs
SYSTEM_DASHBOARD
Game Economy Analytics

Albion Analytics Suite

Real-time market arbitrage engine and crafting calculator for MMORPG economies. Processes massive JSON datasets for economic analysis.

Main Dashboard & Tool Selection Hub
01 // Main Dashboard & Tool Selection Hub
Mobile-First Design for Second-Screen Usage
02 // Mobile-First Design for Second-Screen Usage
Complex Profit Calculator & Margin Analysis
03 // Complex Profit Calculator & Margin Analysis
Normalized Data Schema & API Response Structure
04 // Normalized Data Schema & API Response Structure

Deployment

Private Network Only

Technology Stack

PostgreSQLNode.jsRedisChart.js

Key Features

  • Real-time Black Market arbitrage scanner
  • Complex crafting return rate (RRR) calculator
  • Historical price plotting with Chart.js
  • Mobile-responsive data tables

The Challenge

Processing and normalizing massive JSON datasets from the game API in real-time to find arbitrage opportunities. The main bottleneck was calculating profit margins across 5 different in-game cities simultaneously without blocking the main thread.

The Solution

We built a normalized PostgreSQL schema to handle complex item relationships. A Redis caching layer sits between the API and the frontend to serve "hot" market data instantly. Complex calculations are offloaded to Node.js worker threads.