Next.js job board dedupe with Postgres upsert

I dedupe scraped jobs with a single Postgres unique key. I normalize URLs + titles before hashing....