Re:Hosting SQLite databases on GitHub Pages or any static fi...
by pfundstein on Sunday May 02, 2021 @07:46PM
(#27020126)
I would say it's less overhead than downloading the entire db to query it locally...? What is your suggestion for accessing a static database with less overhead?
[ Parent
| on HN ]
Re:Hosting SQLite databases on GitHub Pages or any static fi...
by OskarS on Monday May 03, 2021 @03:17AM
(#27022467)
I would bet that if you compare it to a traditional server-client database (which functionally does essentially the same thing: you send it a query over the network, and get a result back), the overhead is probably massive. This is a very clever way to cram that kind of functionality into a static hosting site, and you can imagine some uses for it, but it's clearly not a particularly efficient compared to doing it the "right" way.
Re:Hosting SQLite databases on GitHub Pages or any static fi...
by Salgat on Monday May 03, 2021 @02:35AM
(#27022272)
The idea is that you're weighing the pros cons vs an actual live database. This is basically only a good idea if you're having someone else paying the hosting fees.
Re:Hosting SQLite databases on GitHub Pages or any static fi...
by OOPMan on Tuesday May 04, 2021 @08:12AM
(#27036727)
Since it's a static database and the queries against it are most likely going to be static, just pre-run the queries and store the results statically in a more space-efficient format. When you're on a dogshit internet connection in a 3rd world country 50kb can actually be pretty unpleasant. Try rate limiting your internet to EDGE rated to see what I mean.
I'm not saying the whole thing isn't impressive, just that the concept itself is one of those "because I can" rather "because I should" things, which kinda devalues it a whole lot.