Spar Studio Logo
Spar Studio
SYSTEM_DASHBOARD
Game Economy Analytics

Albion ToolKit

Real-time market arbitrage engine and crafting calculator for MMORPG economies.

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.

The Solution

We built a normalized PostgreSQL schema to handle 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.