#collection-654c39b3f934e973c552ba58 .header-nav-list { display: none; }
  • Home
  • Memento Peoni
  • Persistence of Vision
  • Education
  • Inquiries
  • About
  • Diary
Menu

MARK|KIRSCH

Original Photographic Monoprints
  • Home
  • Memento Peoni
  • Persistence of Vision
  • Education
  • Inquiries
  • About
  • Diary
×
Contact Sheet — Print Inventory
Studio Inventory — Setup Needed

One-time setup

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.
Saved
Total Pieces
—
Total Value
—
In Studio
—
Sold
—
Title Medium Created Size Status Value Loanee / Sold To Notes
No prints match that search.
Gelatin XFR — silver gelatin transfer prints · figures in USD Connecting…