📷

GearVault

Camera equipment tracking with Microsoft authentication

Setup Required

To get started you'll need a Supabase project configured with your tables, storage buckets, and Microsoft (Azure) OAuth.

Quick start: Create a free project at supabase.com, then follow the steps below.

Go to Supabase Dashboard → New project
Open the SQL Editor and run the setup script shown below to create your tables and security policies
Go to Storage → create two public buckets named photos and documents
Go to Authentication → Providers → Azure, enter your Azure Application (client) ID and Secret, and note the Supabase callback URL to register in Azure
Copy your Project URL and anon public key from Project Settings → API and paste them below

Supabase Project URL

Anon (Public) Key

SQL Setup Script

Run this in your Supabase SQL Editor to create tables and security policies:

-- ═══ GearVault Tables ═══
create table if not exists gear (
  id text primary key,
  user_id uuid references auth.users(id) on delete cascade,
  ownership text not null default 'personal',
  created_at bigint,
  data jsonb not null default '{}'
);
create table if not exists kits (
  id text primary key,
  user_id uuid references auth.users(id) on delete cascade,
  created_at bigint,
  data jsonb not null default '{}'
);
create table if not exists settings (
  user_id uuid primary key references auth.users(id) on delete cascade,
  api_key text, cse_id text, search_site text
);
create table if not exists admins (
  email text primary key
);

-- ═══ Row Level Security ═══
alter table gear     enable row level security;
alter table kits     enable row level security;
alter table settings enable row level security;
alter table admins   enable row level security;

-- Gear: personal items (own user only)
create policy "gear_personal_select" on gear for select
  using (user_id = auth.uid() and ownership = 'personal');
create policy "gear_personal_insert" on gear for insert
  with check (user_id = auth.uid() and ownership = 'personal');
create policy "gear_personal_update" on gear for update
  using (user_id = auth.uid() and ownership = 'personal')
  with check (user_id = auth.uid() and ownership = 'personal');
create policy "gear_personal_delete" on gear for delete
  using (user_id = auth.uid() and ownership = 'personal');

-- Gear: company items (any @dignetix.com can read; admins can write)
create policy "gear_company_select" on gear for select
  using (ownership = 'company' and auth.jwt()->>'email' like '%@dignetix.com');
create policy "gear_company_insert" on gear for insert
  with check (ownership = 'company' and exists (select 1 from admins where email = auth.jwt()->>'email'));
create policy "gear_company_update" on gear for update
  using (ownership = 'company' and exists (select 1 from admins where email = auth.jwt()->>'email'))
  with check (ownership = 'company' and exists (select 1 from admins where email = auth.jwt()->>'email'));
create policy "gear_company_delete" on gear for delete
  using (ownership = 'company' and exists (select 1 from admins where email = auth.jwt()->>'email'));

-- Kits: own user only
create policy "kits_own" on kits for all using (user_id = auth.uid());

-- Settings: own user only
create policy "settings_own" on settings for all using (user_id = auth.uid());

-- Admins: @dignetix.com users can read and insert (bootstrap); only existing admins can delete
create policy "admins_select" on admins for select to authenticated using (auth.jwt()->>'email' like '%@dignetix.com');
create policy "admins_insert" on admins for insert to authenticated with check (auth.jwt()->>'email' like '%@dignetix.com');
create policy "admins_delete" on admins for delete to authenticated using (exists (select 1 from admins a where a.email = auth.jwt()->>'email'));

📷

GearVault

Track and manage your camera equipment

Sign in

Sign in with your Dignetix Microsoft account to access your gear inventory.

Loading GearVault…

GearVault

Setup Required

SQL Setup Script

📊 Dashboard

📦 Recent Gear

🔍 Away from Home

🎛️ My Gear

🎒 Kits

⚙️ Settings

🔍 Price Lookup API

⬆️ Import & Export

🛠️ Advanced

👨‍💼 Admin Controls

GearVault

Setup Required

SQL Setup Script

GearVault

Sign in

📊 Dashboard

📦 Recent Gear

🔍 Away from Home

🎛️ My Gear

🎒 Kits

⚙️ Settings

🔍 Price Lookup API

⬆️ Import & Export

🛠️ Advanced

👨‍💼 Admin Controls

Add Gear Item

Create Kit

🔍 Price Lookup