Admin Panel

Required to publish changes. A Classic token (repo scope) is most reliable. Generate one at GitHub → Settings → Developer Settings → Personal Access Tokens.

1. Create a free project at supabase.com
2. Run this SQL in the SQL Editor:

create table card_stats (card_id text primary key, download_count bigint default 0, rating_total bigint default 0, rating_count bigint default 0);
alter table card_stats enable row level security;
create policy "pub" on card_stats for all using (true) with check (true);
create or replace function increment_download(p_card_id text) returns void language plpgsql as $$ begin insert into card_stats(card_id,download_count) values(p_card_id,1) on conflict(card_id) do update set download_count=card_stats.download_count+1; end; $$;
create or replace function add_rating(p_card_id text,p_rating int) returns void language plpgsql as $$ begin insert into card_stats(card_id,rating_total,rating_count) values(p_card_id,p_rating,1) on conflict(card_id) do update set rating_total=card_stats.rating_total+p_rating,rating_count=card_stats.rating_count+1; end; $$;
grant execute on function increment_download to anon; grant execute on function add_rating to anon;

3. Find your URL and anon key under Project Settings → API