Ivan Enderlin 🦀 @hywan@floss.social
Public

Hosting SQLite databases on Github Pages, phiresky.github.io/blog/2021/h.

SQLite is compiled to Wasm. The database is statically hosted on a server. A custom layer extracts _ranges_ of this database so that it can be fetched via HTTP. It allows to run SQLite client-side with a static read-only database.
Bonus: it is extended to query the DOM with SQL, this time with read and write mode.

Hosting SQLite databases on Github Pages - (or IPFS or any static file hoster) - phiresky's blog

I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a

phiresky.github.io

0
0
0

If you have a fediverse account, you can quote this note from your own instance. Search https://floss.social/users/hywan/statuses/115490227777924456 on your instance and quote it. (Note that quoting is not supported in Mastodon.)