Game
Beltway Realms Card Database
Full-stack searchable card database built around 700 cards, SQLite FTS5 search, side-by-side comparison, synergy-aware loadout logic, community ratings, and a lightweight analytics layer.
Stack
React 19, TypeScript, Vite, SQLite (FTS5), Hono.js, better-sqlite3, React Router 7
Impact
Shows product and systems thinking through search, recommendation logic, loadout modeling, and a real full-stack interface.
Beltway Realms Card Database
This is a playful project on the surface, but technically it is one of the clearest examples in my portfolio of building a complete product system around search, structured data, and interaction flows.
What I built
- React + TypeScript frontend for browsing, filtering, comparing, and assembling loadouts
- Hono.js backend exposing card, stats, comparison, and loadout endpoints
- SQLite database with FTS5 full-text search and structured entity relationships
- Similar-card recommendations and synergy-aware loadout logic
- Ratings and lightweight usage-stat behavior
Why it matters
The fantasy theme is not the main point. The engineering value is in the underlying system design: search, recommendation behavior, comparison flows, and product logic built on top of a real data model.
What this project shows
- full-stack product engineering ability
- comfort with structured data and search systems
- instinct for making complex information browseable and explorable
- ability to build something that feels interactive and complete