Metro Sports Arena — Edge-Native Venue Management & Multi-Channel Booking Platform

Project Overview

Metro Sports Arena is a premier multi-sport recreational complex located in the high-density tech corridor of Tathawade, Pune. Hosting multiple professional badminton courts, table tennis arenas, pool tables, and outdoor turf facilities, the venue experiences intense demand during morning and evening peak hours.

Dhimahi Technolabs was engaged as the Lead Full-Stack Architect and Technical Delivery Partner to replace an unstable legacy prototype with an enterprise-grade, edge-native venue operations and real-time e-commerce platform. Deployed on Cloudflare Workers using Next.js 16 (App Router) and React 19, the platform unifies direct consumer reservations, automated payments, and external aggregator channels into a single synchronized source of truth.

The Challenge

Prior to Dhimahi Technolabs' engagement, the facility was held back by fragile digital infrastructure that cost the venue both revenue and customer trust:

1. Unstable, Broken Payment Architecture

The venue operated on a disjointed proof-of-concept (Astro frontend paired with three decoupled Cloudflare Workers). Payment processing had never successfully completed a single live transaction, leaving the venue completely dependent on manual phone bookings and unstructured UPI transfers.

2. Single-Slot Booking Friction

Customers were forced to select only one court for a single hour per transaction. Booking a two-hour badminton match or reserving two adjacent courts required multiple repetitive checkout flows, resulting in high abandonment rates.

3. Severe Double-Booking Conflicts

The system lacked concurrency locks. When walk-in players arrived at the front desk or third-party sports platforms (such as KheloMore, Playo, and District) accepted bookings, courts were frequently double-booked, creating heated customer disputes on-site.

4. Zero Administrative Tooling

Venue staff possessed no centralized management console. Managing maintenance blocks, recurring coaching clinics, dynamic weekend pricing, and customer refunds required direct manual database manipulation.

Our Solution & Architecture

Dhimahi Technolabs completely re-architected the system into a unified, edge-hosted platform operating on Cloudflare's global network:

[ Customer / Mobile Client ] ──► [ Cloudflare Edge Workers (Next.js 16 App Router) ]
                                          │
                  ┌───────────────────────┼────────────────────────┐
                  ▼                       ▼                        ▼
       [ Cloudflare D1 SQLite ]   [ Cloudflare KV Cache ]   [ Cloudflare R2 Media ]
       (Atomic Slot Holds & DB)   (Sessions & Rate Limits)  (Receipts & Assets)
                  │
                  ├───────────────────────┬────────────────────────┐
                  ▼                       ▼                        ▼
       [ Razorpay Webhooks ]     [ 2Factor SMS Alerts ]   [ B2B Channel Partner API ]
       (Instant Auto-Refunds)    (DLT-Compliant Alerts)   (KheloMore, Playo, District)

Core Engineering Deliverables

1. Edge-Native Booking Engine with Atomic Slot Holds

We engineered an ultra-fast checkout workflow operating at the edge. Customers authenticate instantly using passwordless SMS OTP. The shopping cart supports multi-court, multi-hour selection in a single transaction, protected by an atomic 10-minute temporary slot hold in Cloudflare D1. This prevents race conditions and guarantees that no other user or aggregator can claim the court while payment is in flight.

2. Automated Payments & Self-Service Account Portal

We integrated Razorpay with automated order creation, cryptographic signature verification, and resilient webhook handling. Customers gain access to a dedicated self-service portal (/account) where they can view digital receipts, reschedule slots, or trigger automated cancellations governed by dynamic refund policies.

3. Comprehensive Staff Venue Console (/admin)

We built a mobile- and desktop-optimized operations suite for venue managers:

• Interactive Day Grid: A visual real-time timeline across all courts with one-click maintenance blocking.
• Bulk & Recurring Reservation Engine: Enables staff to book weekly coaching academies or corporate leagues up to 3 months in advance.
• Dynamic Pricing Engine: Flexible rules for peak, off-peak, weekend, and holiday rates.
• Financial Audit Telemetry: Real-time revenue analytics, court utilization rates, and one-click refund handling.

4. B2B Aggregator Channel API (KheloMore Channel API v1.0)

To capture external aggregator demand without double-booking chaos, we architected a certified venue-partner API (app/api/channel/[env]/v1). The API provides secure, API-key-authenticated endpoints for live availability querying, atomic slot reservation, and maintenance blocking. We engineered an isolated multi-tenant sandbox directly inside the production database using virtual test courts (Court 98 & Court 99), enabling KheloMore engineers to complete all 21 certification test suites without risking live customer inventory.

5. Omnichannel SMS Automation

Integrated with 2Factor.in using DLT-compliant templates. Customers receive instant transactional SMS notifications for bookings, reschedules, and cancellations, with simultaneous alerts routed to on-site reception staff.

Results & Measurable Impact

The platform launched to production at https://metrosportsarena.com, immediately transforming venue operations:

• 100% Production Reliability: Successfully live and processing real customer bookings and live Razorpay transactions with zero critical downtime.
• Sub-100ms Global Edge Response Times: Deployed across Cloudflare Workers, delivering near-instant page transitions and eliminating server cold starts.
• Zero Double-Bookings: Atomic 10-minute slot hold reservation engine completely eradicated double-booking conflicts across walk-in, web, and aggregator channels.
• 100% Automated Payment & Refund Reconciliation: Manual payment verification and UPI chasing were completely eliminated; webhooks handle order confirmation and policy-based refunds instantly.
• Unified Multi-Channel Inventory: Real-time bidirectional synchronization with KheloMore and automated partner SMS ingestion unified all booking channels under a single source of truth.
• Near-Zero Cloud Infrastructure Costs: The serverless edge architecture eliminated traditional cloud VM, container, and database hosting bills.

Technical Challenges & Solutions

Challenge 1: Bleeding-Edge Framework on Edge Runtimes

• The Hurdle: Running Next.js 16 with React 19 on Cloudflare Workers via OpenNext introduced edge runtime bundling constraints and unsupported Node.js native APIs.
• The Solution: We enforced clean runtime separation, leveraged Web Standard APIs (fetch, crypto, Request/Response), and optimized package tree-shaking to keep the worker bundle ultra-compact and compliant with Cloudflare's execution limits.

Challenge 2: High-Concurrency Slot Reservations on Distributed SQLite

• The Hurdle: During peak evening rush hours, simultaneous customer checkouts risked race conditions on Cloudflare D1.
• The Solution: We designed an atomic slot reservation model with indexed expiration timestamps. Unpaid slots automatically expire after 10 minutes, and state queries enforce transaction isolation before initiating Razorpay checkout orders.

Challenge 3: Partner API Certification Without Staging Costs

• The Hurdle: KheloMore required end-to-end integration testing against our live API, but maintaining a duplicate staging database and worker environment was cost-prohibitive.
• The Solution: We engineered a multi-tenant sandbox system within the existing production database using dedicated virtual test courts (Court 98 & Court 99). This allowed KheloMore's QA team to run all 21 certification test suites against live edge endpoints without impacting real customer court availability.