Find your dream gig faster on Who’s Hiring Hacker News with GPT and Metabase
May 21, 2025 - dev.to
The article discusses a project designed to streamline the process of finding job opportunities on Hacker News' "Ask HN: Who is hiring?" threads. The author developed a tool using OpenAI's GPT for parsing, PostgreSQL for data storage, and Metabase for data visualization. This tool fetches job posts from Hacker News, extracts key information such as company, role, location, salary, and contact details using GPT, and stores the data in a PostgreSQL database. Users can then explore and filter this data through a Metabase interface, making it easier to find relevant job listings.
The article also suggests potential enhancements for the project, such as automating monthly updates with GitHub Actions, deploying a public Metabase dashboard, and setting up notification alerts for new job postings. The author encourages readers to explore the project on GitHub, try it out, and contribute by suggesting features or improvements.
Key takeaways:
The project transforms Hacker News job posts into structured, searchable data using OpenAI, PostgreSQL, and Metabase.
GPT is used to parse job post comments, extracting fields like company, role, location, salary, and contact into JSON format.
Parsed data is stored in a PostgreSQL database, allowing for easy exploration and filtering through Metabase.
Potential enhancements include automating updates, deploying a public dashboard, and adding notification alerts for new job postings.
