Project ideas from Hacker News discussions.

Nearest Pint

📝 Discussion Summary (Click to expand)

Theme 1 – Perceived low pub count despite tourism

"Really surprising that Inverness and Skye have only 16 pubs considering how much tourism the area has." – jrflo

Theme 2 – Data may be incomplete; community can help fill gaps

"It looks like the data is from OpenStreetMap so maybe you could add them if they’re missing there?" – CiaranMcNulty

Theme 3 – Many locals feel pubs are missing in their area

"A good third of the pubs are missing in my town tbh and they're definitely still open." – wetbaby


🚀 Project Ideas

Generating project ideas…

OpenPubs Mapper

Summary

  • A crowdsourced web app that identifies missing pubs in local areas using OpenStreetMap and FHRS data, visualizing gaps on an interactive map.
  • Solves the pain point of inaccurate or incomplete pub listings for tourists and locals.

Details

Key Value
Target Audience Local residents, tourists, travel bloggers
Core Feature Interactive map highlighting missing pubs with source verification
Tech Stack React, Leaflet, PostgreSQL, FHRS API, OpenStreetMap
Difficulty Medium
Monetization Hobby

Notes

  • HN commenters noted missing data and suggested contributing to OSM; this directly addresses that.
  • Could spark community contributions and become a go‑to reference for pub hunters.

PubsLive API

Summary

  • A lightweight REST API that continuously syncs with the GetTheData Open Pubs dataset, providing up‑to‑date pub existence and hygiene rating info.
  • Addresses the need for reliable, programmatic access to current pub data.

Details

Key Value
Target Audience Developers, data journalists, app creators
Core Feature Real‑time pub existence endpoint with hygiene rating and location
Tech Stack FastAPI, PostgreSQL, FHRS Open Pubs feed, Docker
Difficulty Low
Monetization Revenue-ready: Freemium tier with usage limits

Notes

  • Users asked about data source; a stable API would satisfy that curiosity and enable new tools.
  • Potential for discussion on data freshness and developer use cases.

PubAlert Bot

Summary

  • A Discord/Telegram bot that alerts users when a new pub appears in a specified region or when a listed pub closes, using the FHRS feed.
  • Provides timely updates to communities that rely on accurate pub listings.

Details

Key Value
Target Audience Local residents, pub enthusiasts, community moderators
Core Feature Subscription‑based alerts for pub openings/closures in chosen postcodes
Tech Stack Python, Telegram Bot API or Discord.py, FHRS Open Pubs webhook, Redis
Difficulty Medium
Monetization Revenue-ready: Subscription $3/month for premium channels

Notes

  • Directly references the comment about civic duty and missing pubs; users would appreciate automated alerts.
  • Could generate lively discussion and be integrated into existing community platforms.

Read Later