First time? You need a free
Supabase account. Create a project, then run the SQL below to set up your tables.
Step 1 — Run this SQL in Supabase → SQL Editor
-- Run this in Supabase → SQL Editor → New Query
create table if not exists site_config (
id integer primary key default 1,
name text default 'Dragsterjack',
bio text default 'Content creator focused on fun & outdoors.',
avatar_url text default '',
footer_text text default '© Dragsterjack 2025',
constraint single_row check (id = 1)
);
create table if not exists site_links (
id uuid primary key default gen_random_uuid(),
label text not null,
url text not null,
handle text default '',
icon text default 'link',
sort_order integer default 0,
created_at timestamptz default now()
);
create table if not exists site_post (
id integer primary key default 1,
platform text default 'youtube',
title text default '',
link text default '',
banner text default '',
description text default '',
active boolean default false,
constraint single_row check (id = 1)
);
-- Allow public read & write (admin password protects frontend)
alter table site_config enable row level security;
alter table site_links enable row level security;
alter table site_post enable row level security;
create policy "Public read config" on site_config for select using (true);
create policy "Public write config" on site_config for all using (true);
create policy "Public read links" on site_links for select using (true);
create policy "Public write links" on site_links for all using (true);
create policy "Public read post" on site_post for select using (true);
create policy "Public write post" on site_post for all using (true);
-- Seed default rows
insert into site_config (id) values (1) on conflict (id) do nothing;
insert into site_post (id) values (1) on conflict (id) do nothing;
Step 2 — Enter your Supabase credentials
Find these in Supabase → Project Settings → API
The public "anon" key — safe to use in a website.
Paste a direct link to your profile photo. Try uploading to Imgur or Supabase Storage.
