CleanJobData + Supabase

1Create a jobs table

Create a PostgreSQL table matching CleanJobData's schema.

CREATE TABLE jobs (
  id BIGINT PRIMARY KEY, title TEXT NOT NULL,
  company TEXT, location TEXT, salary_min NUMERIC,
  description TEXT, posted_at TIMESTAMPTZ
);

2Write a sync function

Create a function that fetches from CleanJobData and upserts into Supabase.

3Add full-text search

Set up PostgreSQL full-text search on your synced job data.

ALTER TABLE jobs ADD COLUMN search_vector TSVECTOR
  GENERATED ALWAYS AS (to_tsvector('english', title || ' ' || description)) STORED;
CREATE INDEX jobs_search_idx ON jobs USING GIN(search_vector);