Guild Analytics

System Architecture

⚡ 100% FREE & SERVERLESS ⚡

Azeroth's Most Wanted Armory operates on a fully automated, zero-cost tech stack. By combining edge databases, static site generation, and GitHub Actions, the dashboard processes thousands of data points a day without a traditional backend or any recurring hosting fees.

STEP 1: EXTRACTION

Asynchronous Pull

Python utilizes AsyncIO and Aiohttp to concurrently fetch live character profiles from the Blizzard REST API, processing vast amounts of data in seconds.

STEP 2: STORAGE

Edge Database

Processed data is pushed in bulk transactions to a Turso edge database (libSQL/SQLite). This allows for infinite, free storage of historical guild trends and loot timelines.

STEP 3: AUTOMATION

CI/CD Pipeline

GitHub Actions acts as our server. A strict Cron schedule triggers the pipeline to update the database and rebuild the website without human intervention.

STEP 4: COMPILATION

Static Generation

Jinja2 templates inject the latest database queries into raw HTML. The result is a lightning-fast, ultra-secure static frontend powered by HTML5 and modern CSS.

STEP 5: VISUALIZATION

Client-Side Rendering

Heavy payloads are pre-compiled into static JSON files. The frontend consumes this data natively, using Chart.js to render analytics with zero database latency.

Guild Overview