I wrote a very niche ebook about GTFS public transit data

In plain words

This is an ebook that teaches readers how to work with GTFS (General Transit Feed Specification), the standard format for public transportation data. It covers the structure of GTFS feeds, importing data into SQL databases, querying transit information like trips and fares, and database optimization techniques. The resource is designed for developers and transit data professionals who need to consume and work with open public transportation datasets.

written from the facts on this page · September 2026

From the sources

Save $5 by buying both books together!Book 1 - The Definitive Guide to GTFSLearn all about the General Transit Feed Specification (GTFS) and how to consume open public transportation data, including:All about the structure of a GTFS feedHow to import a GTFS feed to an SQL database and perform queriesHow to search for trips, handle blocks and calculate faresTechniques for optimizing a GTFS database

• AL
  A library of GTFS Realtime translators (for transit data)2019 · ixn.intersection.com · ▲12
• 
  I built a transit travel time map2023 · map.henryn.xyz · ▲255

  This was something I built while trying to look for housing in Toronto that was decently transit-accessible to my office while still cheap. The backend is written in Rust. It parses public GTFS data from transit agencies and performs a simple heuristics-based BFS on the bus lines to calculate how long to reach all points in a city. The frontend uses React and Mapbox GL to render each individual road segment based on how long it takes to reach. This project was a great excuse to learn Rust, deployments, and mapping. The source code is here if you are interested:…

• 
  I mapped HN's favorite books with GPT-4o2024 · hnbooks.pieterma.es · ▲285

  Hey HN! I love finding new books to read on here. I wanted to gather the most mentioned books and recreate the serendipity of physical browsing. I scraped 20k comments from HN threads related to reading, extracted the references and opinions using GPT-4o mini, and visualised their embeddings as a map. - OpenAI's embeddings were processed using UMAP and HDBSCAN. A direct 2D projection from the text embeddings didn't yield visually interesting results. Instead, HDBSCAN is first applied on a high-dimensional projection. Those clusters tend to correspond to different genres. The genre…

• 
  Data Engineering Book – An open source, community-driven guideFeb 2026 · github.com · ▲251

  Hi HN! I'm currently a Master's student at USTC (University of Science and Technology of China). I've been diving deep into Data Engineering, especially in the context of Large Language Models (LLMs). The Problem: I found that learning resources for modern data engineering are often fragmented and scattered across hundreds of medium articles or disjointed tutorials. It's hard to piece everything together into a coherent system. The Solution: I decided to open-source my learning notes and build them into a structured book. My goal is to help developers fast-track their learning curve. Key…

• 
  Free e-book about WebGPU Programming2024 · shi-yan.github.io · ▲471

  I am excited to announce the launch of my e-book on Graphics/WebGPU programming! This project has consumed much of my spare time, during which I developed various tools to facilitate the publishing process, including a code playground and a static site generator that can reference sample codes. However, I'm feeling burnt out and ready to call it finished, even though it may not feel completely done. Avoiding another abandoned side project has been my primary motivation in reaching this point.

• PT
  Public transit systems as data – lines, stations, railcars, and historyMar 2026 · publictransit.systems · ▲47

  Comprehensive information about public transit systems worldwide.

• 
  Run full iOS 16.5 firmware on Android Devices▲513

  Contribute to oosexgang/hackios-xnu-kernel development by creating an account on GitHub.

  Dev tools · 1d ago · github.com

• 
  /dev/null▲492

  a social network for devs

  Dev tools · 4d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 29d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 24d ago · openbot.run

• 
  Talanoa▲346

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 22d ago · talanoa.email

• 
  Recordit▲564

  A faster way to take screencasts Free + GIF Support

  Life & fun · 2014 · placeit.net

• 
  thedaywefightback.js▲472

  Add a banner to your site in opposition to mass surveillance on 02/11 - tfrce/thedaywefightback.js

  Life & fun · 2014 · github.com

• 
  OneTab▲458

  Save 95% memory by converting all your open tabs into a list

  Work · 2014 · one-tab.com

• JL
  JS library to make your website instant▲426

  http://instantclick.io/ It seems the internet architecture won't bring us instant websites anytime soon. So here is a hack. I released this JS library last month (today is version 2.0 release, fixing v1.0's rough edges), it makes use of HTML5's pushState and preloading to make a website instant. It works like this: before clicking on a link, you'll hover over it. And there's a delay of 200-300 ms between these two events. InstantClick uses this delay to preload a page, when you click on a link it will display instantly in most case. (You can test on the website.) That's…

  Life & fun · 2014

• IR
  I redesigned the Microsoft employee badge▲322

  For a while, I had this idea of redesigning Microsoft employee badges for a modern and neat look. So I spared a few hours this weekend. It’s over a year Microsoft has started to rebrand itself, starting from its logo to a brand new looking OS, from campus shuttles to direction signs on the cam

  Life & fun · 2014 · alp.im

• 
  Hemingway▲320

  Hemingway makes your writing bold and clear.

  Life & fun · 2014 · hemingwayapp.com