Backend & Monetization

Novactorio's backend is Supabase (auth, realtime, Postgres, storage) with Stripe payments handled by four Deno Edge Functions.

Services

Service	Role
Supabase Auth	Accounts, sessions (`@supabase/supabase-js` ^2.57)
Supabase Realtime	Co-op multiplayer: player positions + build actions
Supabase Postgres	World snapshots, profiles, trades
Supabase Storage	Save data / snapshot storage
Stripe	Checkout subscriptions (Starter/Premium) + trade fees
Deno Edge Functions	Payment orchestration + webhooks

Database (supabase-schema.sql)

Key tables:

Table	Purpose
`profiles`	User profiles; `premium_tier` updated by webhooks
`world_snapshots`	Cloud saves (`save_data` payload)
trades / trade state	Player-to-player trading

Edge functions (`supabase/functions/`)

Function	Purpose
`stripe-checkout`	Creates a Stripe Checkout session for premium subscriptions (Starter/Premium)
`stripe-webhook`	Verifies Stripe webhooks; updates `profiles.premium_tier`
`trade-fee-checkout`	Checkout for trade fee payments
`trade-webhook`	Confirms trade fees and settles trades

Flow: premium subscription

Player clicks "Go Premium"
      │
      ▼
stripe-checkout (Edge Function)
      │  creates Checkout Session
      ▼
Stripe Checkout page (hosted)
      │  payment success
      ▼
stripe-webhook (Edge Function, signature-verified)
      │  updates profiles.premium_tier
      ▼
Player has premium benefits

Flow: player trading

Player A initiates trade with Player B
      │
      ▼
trade-fee-checkout (Edge Function)
      │  fee payment processed
      ▼
trade-webhook (Edge Function)
      │  settles trade, transfers assets
      ▼
Both players receive items

Co-op multiplayer

Supabase Realtime broadcasts:

Player positions — live movement of other players
Build actions — place/remove events replicated to all clients

Cloud saves

World snapshots are backed up to Supabase:

world_snapshots.save_data holds serialized world state
Restorable from the game's save/load UI

Environment variables

Variable	Purpose
`VITE_SUPABASE_URL`	Supabase project URL
`VITE_SUPABASE_ANON_KEY`	Supabase anon (publishable) key
`VITE_ADMIN_USERS`	Comma-separated admin usernames
Stripe secret keys	Edge function secrets (Stripe API + webhook signing)

Deployment

# Deploy edge functions
supabase functions deploy

# Deploy the game to Cloudflare
npm run deploy   # = npm run build && wrangler deploy

Configuration lives in wrangler.jsonc; Supabase CLI handles function deployments with per-function secrets.