placeholder

Hosting SQLite databases on Github Pages - (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

Click to view the original at phiresky.github.io

Hasnain says:

This is so cool. When I had to do something similar ages ago (holy crap, I feel old) I ended up sharding the dataset into static flat files and filtering on the client. While that’s still held up, this is just much more flexible and easier to update.

“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 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).”

Posted on 2021-05-02T23:08:02+0000