Fetches job postings from "Who is hiring?" threads on Hacker News, parses them with OpenAI, and stores them in Postgres for Metabase dashboards. Also exports to CSV.
CREATE SCHEMA IF NOT EXISTS hn; CREATE TABLE hn.jobs ( hn_comment_id bigint primary key, company text, role text, location text, salary text, contact text, description text, posted_at timestamp with time zone, created_at timestamp with time zone default now(), updated_at timestamp with time zone default now() );