Hosting SQLite Databases on Static File Hosts Like GitHub Pages and IPFS

But if you want to use a database, you either need to write a backend (which you then need to host and maintain forever) or download the whole dataset into the browser (which is not so great when the dataset is more than 10MB).

In the past when I've used a backend, I've often found myself maintaining it for years, even when the project was just a small weekend project.

The solution is to use SQLite compiled to WebAssembly (WASM) and host the database file on a static file hoster like GitHub Pages, IPFS, or any other static file hosting service.

This approach allows you to query the database directly in the browser without needing a backend server, while still being able to efficiently query only the data you need.