gtfs-sqlite

🚌🚇 A TS/JS library to import a GTFS file into a sqlite database, completely in the browser.

Try the demo here.

How it works

The sqlite database is stored in the Origin Private File System, and accessed via sqlite-wasm running in a WebWorker thread.

There means there is a slight overhead for each sql command, but it allows you to execute complex and expensive queries without blocking the main thread.

There is one exception: When importing a dataset, we run this in the main thread because it's significantly faster, but it will cause the browser to appear unresponsive, despite some logic to minimise the sluggishness.