GitHub - matthewhefferon/hn-jobs-to-metabase: Making Hacker News Jobs Searchable Using GPT + Metabase
May 21, 2025 - github.com
The article describes a system that collects job postings from the "Who is hiring?" threads on Hacker News. It uses OpenAI to parse the job postings and stores the data in a PostgreSQL database, specifically in a schema named "hn" and a table called "jobs." The table includes fields for the comment ID, company, role, location, salary, contact information, job description, and timestamps for when the job was posted and when the record was created or updated.
Additionally, the system exports the collected job data to a CSV format. This setup allows for the creation of Metabase dashboards to visualize and analyze the job postings data. The use of PostgreSQL ensures that the data is structured and easily accessible for further processing and insights.
Key takeaways:
Automates the process of fetching job postings from Hacker News "Who is hiring?" threads.
Utilizes OpenAI for parsing job postings to extract relevant information.
Stores parsed job data in a Postgres database for use in Metabase dashboards.
Provides an option to export job data to CSV format.
