myrookie

Phoenix + LiveView app for basketball prospect discovery, card browsing, and reviews.

Tech Stack

• Elixir / OTP
• Phoenix 1.7 + Phoenix LiveView
• Ecto + PostgreSQL
• Tailwind + esbuild
• Supabase (auth/data integration)
• Fly.io deployment

Prerequisites

• Elixir ~> 1.14
• Erlang/OTP compatible with your Elixir version
• PostgreSQL (local or hosted)
• Node.js/npm (for frontend assets)

Local Setup

1. Install dependencies and bootstrap project:
   • mix setup
2. Create your local env file:
   • cp .env.example .env
   • On PowerShell: Copy-Item .env.example .env
3. Fill in .env values for your local environment.
4. Start Phoenix:
   • mix phx.server
   • or iex -S mix phx.server
5. Open http://localhost:4000.

Database Bootstrap For Contributors

To create the schema from scratch on a new machine:

1. Copy env file and set DB URL:
   • cp .env.example .env
   • On PowerShell: Copy-Item .env.example .env
   • Make sure SUPABASE_DATABASE_URL points to your local Postgres DB.
2. Run full setup:
   • mix setup

This runs:

• mix ecto.create
• mix ecto.migrate
• mix run priv/repo/seeds.exs

If you want to rebuild DB from zero at any time:

• mix ecto.reset

Environment Variables

Use .env.example as the source of required keys.

• SUPABASE_ANON_KEY: public anon key used by frontend auth flow
• SUPABASE_DATABASE_URL: DB connection URL used by Ecto
• SUPABASE_JWT_SECRET: JWT signer secret (server-side only)
• SUPABASE_URL: Supabase project URL (DEV_MODE for local setup in this repo)
• SUPABASE_SERVICE_ROLE_KEY: service-role key (server-side only)
• SECRET_KEY_BASE: Phoenix secret key base
• PHX_HOST: external hostname
• PORT: app port
• POOL_SIZE: Ecto DB pool size

Useful Commands

• mix setup: deps + db setup + asset build
• mix phx.server: run web server
• mix test: run test suite
• mix ecto.reset: drop + recreate + migrate + seed
• mix assets.deploy: minify assets and digest for production

Deployment

This repo includes Fly.io config:

• App runtime config: config/runtime.exs
• Fly config: fly.toml
• CI deploy workflow: .github/workflows/fly-deploy.yml

For GitHub Actions deploy, set repository secret:

• FLY_API_TOKEN

Security Notes

• Never commit .env or real credentials.
• Keep SUPABASE_SERVICE_ROLE_KEY, SUPABASE_JWT_SECRET, and SECRET_KEY_BASE server-side only.
• Use platform secrets (GitHub/Fly) for production.