I'm also impressed with the implementation for the blog itself. I love this sort of clean, version-tracked sort of implementation.
Hosting SQLite databases on GitHub Pages or any static file hoster
121–130 of 252 posts
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#122This is easily the most clever web programming hack I’ve seen this year. Bravo. I had seen this used for video or audio of course but it never occurred to me you could use it for databases. There are probably a ton of other formats this is good for too.
I wonder if this could be used to serve dynamic maps.
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#123>Of course it can’t write to this file, but a read-only database is still very useful.
perhaps read-only should be added to the title
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#124Modeling the DOM in SQL... Further evidence that anything we can imagine has some stable representation in third normal form. Is it fast? Maybe not. But is it correct? Provably.
There was a group that rewrote the Chromium DOM itself in a data oriented design (which learns from database design and sort of applies to cache utilization and locality) and got a 6X speedup in some places:
https://meetingcpp.com/mcpp/slides/2018/Data-oriented%20desi...
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#125>Of course it can’t write to this file, but a read-only database is still very useful. perhaps read-only should be added to the title
I thought the "static" part of "static file hoster" was clear enough.
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#126Watch dragon ball season 1 full
https://animated2021.blogspot.com/2021/05/dragon-ball-season...
health tips for men and women. We all should know about these things http://healthwithbeauty.xyz/2021/04/20/health-tips-for-men/
watch best funny peter rabbit movie online https://animated2021.blogspot.com/2021/05/watch-peter-rabbit...
Virginia Girls Scouts making cookie deliveries via drone https://www.interestingnews.club/2021/05/virginia-girls-scou...
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#127This is perfect for my need, been looking for a way to add search to my static site completely free of server. Now I can use sqlite as index.
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#128This is certainly a clever hack. But it makes things cheaper and easier for the website owner at the expense of the users. This kind of solution will add to the bloat that is making the web unusable enough that people are seriously proposing a remote browser as a solution for desktop users (remember Mighty the other day?). We shouldn't let the cleverness distract us from this drawback.
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#129Pop open the network pane in the browser tools and try running this SQL query for a demo of how clever this is: select country_code, long_name from wdi_country order by rowid desc limit 100 It fetches just 54.2KB of new data (across 49 small HTTP requests) to return 100 results - from a statically hosted database file that's 668.8MB! I have an animated GIF demo of this here: https://twitter.com/simonw/status/13889338…
mind blown. how is this possible???
TL;DR http, properly implemented, supports a ton more stuff than even many “web developers” are aware of, like… range requests, which are exactly what you’d think they’d be.
Re: Hosting SQLite databases on GitHub Pages or any static file hoster
#130This is perfect for my need, been looking for a way to add search to my static site completely free of server. Now I can use sqlite as index.
This certainly does look like an interesting solution, I'd be keen to try it myself. However, just in case you didn't already know about Lunr (https://lunrjs.com/), it is fairly commonly used to implement search on static websites.
e.g. https://squidfunk.github.io/mkdocs-material/
There are of course other similar libraries too.
EDIT: Whoops, just saw a few comments below Lunr is already mentioned.