CASE · 01 LIVEReal-time marketplace intelligence platform. Live in production.

Aisling Exchange

ReactTypeScriptViteTailwind CSSExpress.jsPostgreSQLSupabaseRechartsReact Router DOMLucide React
01Overview

A real-time marketplace intelligence platform with live data ingestion, price analytics, and a full admin ops dashboard. 5,800+ items tracked across 46 lazy-loaded routes, powered by 22+ custom React hooks with aggressive caching and offline support. Built and shipped end to end as one codebase, one developer. The target community is the Dark Ages MMORPG. The transferable capability is production-grade real-time systems with heavy admin tooling.

02The Challenge

Why build this?

The target community had no centralized way to track live marketplace activity, pricing trends, or coordinate events. Price signals were fragmented across in-game communication and word-of-mouth, and new users had no visibility into fair pricing. The ask: ingest live activity streams, surface actionable market intelligence, and give operators a full admin layer to manage 5,800+ entities without engineering headcount, all in a fast, responsive SPA.

03Features

What it does.

F.01

Marketplace Intelligence

A full market analytics engine ingesting live data streams and surfacing actionable price intelligence.

  • Item price tracking with 7-day, 30-day, and all-time statistics
  • Daily price snapshots with volatility scores and momentum
  • Live activity parsing extracting buy/sell/trade signals in real-time
  • Community price submissions with admin review workflow
  • Trending items dashboard (rising, falling, volatile)
  • Price history charts with configurable time ranges (Recharts)
F.02

Listings & Trading

A marketplace layer where users create listings, negotiate trades, and manage inventory.

  • User-created buy/sell/trade listings with status management
  • Listing reposting and visibility bumping
  • Bulk discount tiers for large-quantity purchases
  • Sprite rendering from shared asset maps
  • Trade offers system with back-and-forth negotiation
F.03

User Directory & Identity

Rich user profiles with identity verification and community directories.

  • Directory with filtered browse across all registered users
  • Achievement and ranking tracking with popularity metrics
  • Group/guild system with membership management
  • Identity verification via in-game whisper challenge
  • User profiles with activity history and contribution metrics
  • Real-time online presence tracking with last-seen data
F.04

Community & Scheduling

Tools for events, groups, and coordinated activities.

  • LFG (Looking For Group) with scheduling and 12-second live polling
  • Events with RSVP, prizes, and recurrence rules
  • Giveaways with cryptographically fair drawing and audit trails
  • Weekly lottery system with verification
  • Community petitions with voting and comments
  • Real-time notification system with user preferences
F.05

User-Generated Content

Editorial workflows with approval and moderation.

  • Community guides by category with full CRUD
  • Edit suggestions with approval workflow
  • News articles with featured-article system
  • Event banners and system announcements
F.06

Admin Ops Dashboard

A full operator layer managing 5,800+ entities without needing engineering involvement.

  • Activity stream linking, item management (~5,800 items)
  • Alias deduplication and fuzzy matching
  • Item merging, manual price entry, submission review
  • Snapshot recalculation and historical data tools
  • Activity browser with bulk deletion and linkable management
  • Role-based access with audit trails
04Architecture

How it's built.

A frontend-heavy SPA backed by a RESTful Express.js API and PostgreSQL database on Supabase. The client runs aggressive caching: an in-memory item store with 5-minute auto-refresh and localStorage caching with 30-minute TTL. 46 routes are lazy-loaded to keep initial bundle small.

L.01

Frontend

React 18.3TypeScript 5.5Vite 5.4Tailwind CSS 3.4React Router DOM 7Recharts 3.7Lucide React
L.02

Backend

Express.jsREST API22+ Custom HooksClient-Side Caching
L.03

Database

PostgreSQLSupabasepg_trgm (text search)uuid-ossp
L.04

Infrastructure

46 Lazy-Loaded RoutesContext API (Auth)In-Memory Item StoreOffline Fallback Support
05In Action
[ PENDING ]

Dashboard Overview

screenshot coming soon

[ PENDING ]

Market Analytics

screenshot coming soon

[ PENDING ]

Item Detail Page

screenshot coming soon

[ PENDING ]

Player Profile

screenshot coming soon

[ PENDING ]

Admin Panel

screenshot coming soon

06By The Numbers

~5,800

Items Tracked

46

Routes

22+

Custom Hooks

Live

Status

07Next

Want something like this
built for you?

Grab a 20-minute call. No pitch deck, no sales funnel. Tell me what you're building and I'll tell you if I'm the right person for it.

Book 20-min callVisit live site
Back to portfolio