Skip to content

jowsey/ow2-data-frontend

Repository files navigation

OW2 Historical Data

A full-stack SvelteKit app for viewing historical Overwatch 2 hero data.

First-time setup

  1. This project is built with Bun. Use bun install to install dependencies.
  2. Fill out a .env based on .env.example
  3. Initialise Postgres with docker compose up -d, then push schema with bun run db:push
  4. Run a development build with bun run dev, or build for production with bun run build and launch with bun run build/

Note that the schema pushed from this app is very lenient and surface-level. It exists only to get database requests returning without error.
You may find it worthwhile to add indexes to the columns used for filtering in schema.ts or your SQL client of choice.

Populating the table with data is left as an exercise for the reader :)

App screenshot featuring ranking tables for hero pick-rates and win-rates, and a chart showing historical win-rates.