SinglePlayerGamers.com
Web application for discovering single-player games. Includes user accounts, newsletter signup, production hosting, and a mobile app shell. A production product I built and operate myself.
Problem & Outcome
Most discovery tools mix multiplayer noise into the catalog. This product is built for single-player only — find games, keep a personal list, and skip the multiplayer-first clutter, battle-pass pressure, and endless uncurated dump.
Outcome: a public site with dual catalog (editorial + algorithm), accounts and cloud-synced My List, newsletter + welcome email, blog, Stuck Assist (ranked video/guide links for in-game moments), production HTTPS hosting, and a Capacitor Android shell on the Play path.
Architecture
The site is static HTML on Cloudflare Pages. Game covers are stored on Cloudflare R2. Accounts, My List, and the newsletter are in Supabase. Welcome email goes out through Resend.
flowchart TB A["Browser / Android"] --> B["Cloudflare Pages"] B --> C["Supabase accounts and My List"] B --> D["Edge Functions"] D --> E["Resend and Stuck Assist"] B --> F["R2 game covers"]
Hosting & Hardware
singleplayergamers.com is on Cloudflare Pages. Game covers are on Cloudflare R2.
Supabase handles accounts, My List, and the newsletter. Resend sends the welcome email. The catalog is published JSON, so people can browse without an account.
API keys stay off the website.
Tech Stack
| Layer | Choice | Why |
|---|---|---|
| Frontend | HTML, Tailwind CDN, vanilla JS | No build step; fast iteration; easy static deploy |
| Game data | Static JSON (curated + algorithm catalogs) | Git-tracked; works without a DB for browse |
| Scoring / ingest | Python + RAWG + IGDB (+ Steam where app id known) | API keys stay local; deploy only the result JSON |
| Backend | Supabase (Auth, Postgres, RLS, Edge Functions) | Accounts, My List, newsletter, Stuck Assist API surface |
| Resend (+ Edge Function welcome flow) | Reliable transactional delivery | |
| Hosting | Cloudflare Pages and R2 | Site files on Pages. Cover images on R2. |
| Mobile | Capacitor (Android shell) | Same web app packaged for Play Store path |
| Analytics | Google Analytics 4 | Traffic and conversion events (e.g. newsletter) |
Takeaways
- A live catalog of single-player games, with accounts and a personal list
- Newsletter signup with a welcome email
- An Android app shell that opens the same site