Public Roadmap

Migrated 160 raw DB calls to safe_query/safe_execute with retry logic and Sentry reporting. Added transaction blocks for atomicity on Enter Results, Edit Tournament, and Delete Tournament. Extracted safe_query_impl to R/safe_db.R for global scope access.

Query timing instrumentation, lazy tab loading, bindCache expansion, pool tuning, batched startup queries, deferred rating recalculation via later::later(), and dashboard preload behind loading screen.

Post-submission Step 3 across Enter Results, Upload Results, and Edit Tournaments for adding decklist URLs. Domain-allowlisted validation (7 approved deckbuilder sites), shared save component, sanitized display.

5 pre-computed views replace multi-table JOINs across all public tabs. Per-store grain design with auto-refresh on admin mutations and Limitless sync.

Deck assignment mismatch, broken tournament deep links, points/WLT format persistence, modal stacking, decklist URL field restored, missing rating recalc on delete/public submit, welcome modal re-query, delete tournament error path.

Unified admin_requests table with notification widget, approve/reject workflow, Discord integration.

Required Discord username, fuzzy store matching, DB persistence, request type dropdowns.

Auto-create Discord forum threads, preview modal, thread ID auto-save, scene announcements.

Search bars, filters, Users tab grouped by scene, required store fields, schedule qualifiers, auto-message templates.

postMessage bridge for mobile localStorage, announcement system, version changelog modal.

Audit columns on tournaments, stores, players, deck_archetypes, and scenes tables.

Pending request cards surfaced directly on admin tabs for quick resolution.

Admin warning toast when post-submission rating recalculation fails silently. Covers all 4 recalculation call sites.

New Casuals event type plus unrated event exclusions (casuals, regulation battles, release events, other) from competitive rating. Achievement scores still include all events.

Upload Results tab accepts Bandai TCG+ CSV exports with validation (file size, columns, data ranges). CSV promoted as recommended upload method.

All Scenes view shows scene summary cards instead of individual stores. Clicking navigates into the scene. Applied to desktop cards, schedule views, and mobile.

Styled player cards with tier-colored rating badges, top-3 left borders, color-coded W-L-T records, full-opacity deck badges, and stronger card borders.

Converted header three-dot dropdown to a styled modal matching admin login pattern. Moved Upload Results from mobile tab bar into the modal (mobile only), reducing tabs from 6 to 5.

Dedicated mobile views for all 5 public pages with JS device detection, stacked card layouts, mobile CSS foundation, and PWA improvements including icon sizes and safe area insets.

Complete overhaul of the competitive rating algorithm with single-pass chronological processing, proper tie handling, and no time-based decay.

Public-facing website at digilab.cards with blog, public roadmap, and landing page. Built with Astro and hosted on Vercel.

Migrated the Shiny app from digilab.cards to app.digilab.cards to make room for the public website.

Fixed player name collisions across scenes with scene-scoped matching and duplicate detection scripts.

Fixed duplicate tournament rows caused by tied first-place finishers from Limitless Swiss events.

Discord webhook system with themed Digimon bots, in-app request modals for stores and scenes, contextual error reporting, and bug report forms.

9 patch releases covering database connection stability, Limitless integration fixes, deck request UX, member number management, global map improvements, dynamic min-event filters, admin dropdown fixes, and international store support.

v1.0 release with PWA support, Agumon mascot (loading, disconnect, 404), performance profiling, responsive grids, lazy admin UI, production hardening, and browser credential saving.

Per-user admin accounts with bcrypt hashing, role-based permissions (super admin / scene admin), scene scoping, manage admins UI, and GA4 custom events.

OCR layout-aware parser (73% → 95% accuracy), Sentry error tracking, FAQ/About/For Organizers rewrites, skeleton loaders, inline form validation, and UX polish round 2.

Three-step onboarding carousel, contextual hints, per-page help text, admin info boxes, and Agumon mascot integration across empty states.

Filter prominence, pill toggles, responsive grids, player attendance filtering, cards view default for stores, flat map projection, and player modal rating sparkline.

Online organizers world map, cards view for stores, community links URL filtering, admin scene filtering, country field for online stores, and unified store modal.

Automated sync of 137 online tournaments from Limitless TCG with deck auto-classification (80+ rules), grid-based bulk entry, paste from spreadsheet, and inline player matching.

Scene hierarchy (Global → Country → State → Metro), scene selector with geolocation, localStorage persistence, pill toggle filters, clickable dashboard cards, historical format ratings, and batched queries.

SQL parameterization for all public queries, safe_query() wrapper, ratings cache tables, bindCache() on 20+ outputs, lazy-load admin modules, visibility-aware keepalive, and SEO files.

Shareable URLs for players, decks, stores, and tournaments with browser history support, Copy Link buttons, and scene URL foundation.

Screenshot-based tournament submission with Google Cloud Vision OCR, match history uploads, deck request queue, mobile bottom tab bar, and admin/super admin two-tier access.

About, FAQ, and For Organizers content pages with footer navigation, Open Graph meta tags, Google Analytics, and branding assets.

Extracted server logic from monolithic app.R (3,178 → 566 lines), created modular server files with public-*/admin-* naming, reactive values cleanup, and CSS cleanup.

Edit results from tournaments tab, required date validation, duplicate tournament flow, and modal input fixes.

Manage Tournaments admin tab, overview click navigation, cross-modal navigation, deck/tournament modal stats, auto-refresh after admin changes, and sidebar reorder.

Renamed from 'Digimon TCG Tracker' to 'DigiLab' with custom domain at digilab.cards.

Modal selection fix, Meta %/Conv % columns, Record column with colored W-L-T, Main Deck column, blue deck badge fix, and default table rows increase.

Competitive Rating (Elo-style), Achievement Score (points-based), and Store Rating (weighted blend) with full methodology documentation.

Responsive value boxes with breakpoints, mobile filter layouts, header spacing, and bslib spacing overrides.

Complete digital Digimon design language — loading screen, empty states, modal stat boxes, digital grid overlays, circuit nodes, title strip filters, and value box redesign.

Initial app with tournament tracking, player standings, deck meta analysis, store directory, admin CRUD, format management, card sync from DigimonCard.io API, and GitHub Pages hosting.