This dashboard stores your data in a free Supabase project so it works from any browser or device.
It takes about 10 minutes, once.
1Create a free Supabase project
Go to supabase.com → sign up → "New project". Pick any name/password/region and wait ~1 minute for it to spin up.
2Create the table
In your project, open the SQL Editor → "New query" → paste this in and run it:
create table pieces (
id text primary key,
title text not null,
medium text,
size text,
date_created int,
image_date int,
status text,
value numeric,
sold_to text,
loan_duration text,
notes text,
image_url text,
created_at timestamptz default now()
);
alter table pieces enable row level security;
create policy "public read" on pieces
for select using (true);
create policy "public write" on pieces
for insert with check (true);
create policy "public update" on pieces
for update using (true);
create policy "public delete" on pieces
for delete using (true);
3Create a storage bucket for photos
Go to Storage → "New bucket" → name it exactly print-photos → toggle it Public → create.
Then back in the SQL Editor, run:
create policy "public read photos" on storage.objects
for select using (bucket_id = 'print-photos');
create policy "public upload photos" on storage.objects
for insert with check (bucket_id = 'print-photos');
create policy "public update photos" on storage.objects
for update using (bucket_id = 'print-photos');
create policy "public delete photos" on storage.objects
for delete using (bucket_id = 'print-photos');
4Copy your keys into this file
In your Supabase project, go to Settings → API. Copy the Project URL and the anon public key.
Open this HTML file in a text editor, find the CONFIG section near the top of the <script> tag, and paste your two values in, then save and reopen the file.
Note: this setup uses fully open access policies for simplicity — anyone with your Supabase URL and anon key could read or edit the data. That's fine as long as you don't share those values publicly. Ask me any time about adding a login so only you can edit it.
Studio Inventory — Live
Contact Sheet
Every gelatin print in circulation — in the studio, on loan, or sold — tracked frame by frame.