Live data from Hacker News

Hosting SQLite Databases on GitHub Pages

phiresky.netlify.app

21–30 of 82 posts

Re: Hosting SQLite Databases on GitHub Pages

#21

Good writeup, thanks! All the code snippets, when run, give me the following error message: [error: RuntimeError: abort(Error: server uses gzip or doesn't have length). Build with -s ASSERTIONS=1 for more info. (evaluating 'new WebAssembly.RuntimeError(e)')] Could that be a Mobile Safari thing?

Same error with Vivaldi 4.1.2369.11 (Chromium based)

Re: Hosting SQLite Databases on GitHub Pages

#24
post #8

Earlier quoted context omitted.

I’m not sure if this is sincere but Apple do not allow other browser engines. They are all Safari skins.

Android is used more here in India. Personally I haven't even touched an Apple device till date because it's just hard to find except in Apple store or if you have very rich friends. So I had no idea. > They are all Safari skins That's crazy.

There might be good reasons to do it from Apple’s point of view.

For example, if Apple allowed third-party browser engines, any vendor could offer a browser with a vulnerability. That browser could be abused to install apps through that vulnerability, including malicious ones.

I’m not implying that it’s ok for Apple to act like that. My point is that it’s consistent with their security model for iOS.

Re: Hosting SQLite Databases on GitHub Pages

#25
post #4

Good writeup, thanks! All the code snippets, when run, give me the following error message: [error: RuntimeError: abort(Error: server uses gzip or doesn't have length). Build with -s ASSERTIONS=1 for more info. (evaluating 'new WebAssembly.RuntimeError(e)')] Could that be a Mobile Safari thing?

Yeah it's sad apple has crippled their browser the browser on a $40 android tablet is more powerful than safari running on a $1200 iPhone

There’s a market for both devices, and justifiably so. Why not celebrate the fact that people have a choice?

Re: Hosting SQLite Databases on GitHub Pages

#26
SQLite not being in browsers instead of indexdb saddens me today still.

I designed a system 15 years ago that released dimensional star schemas for specific reports as sqllite databases into Adobe Air (or whatever the prerelease name was) for a large retailer in the UK. We would query the data warehouse, build the sqlite db file (I can't remember the exact db sizes but they weren't too big - 15mb or so) and the computational performance we got from using sqlite as our crunching layer when building the dimensional reports with drilldown was just astounding.

Re: Hosting SQLite Databases on GitHub Pages

#27

SQLite not being in browsers instead of indexdb saddens me today still. I designed a system 15 years ago that released dimensional star schemas for specific reports as sqllite databases into Adobe Air (or whatever the prerelease name was) for a large retailer in the UK. We would query the data warehouse, build the sqlite db file (I can't remember the exact db sizes but they weren't too big - 15mb or so) and the compu…

You actually can use SQLite on some browsers with WebSQL today. Unfortunately, WebSQL has been deprecated and is already removed from some browsers (https://softwareengineering.stackexchange.com/questions/2202...).

Re: Hosting SQLite Databases on GitHub Pages

#28
post #4

Good writeup, thanks! All the code snippets, when run, give me the following error message: [error: RuntimeError: abort(Error: server uses gzip or doesn't have length). Build with -s ASSERTIONS=1 for more info. (evaluating 'new WebAssembly.RuntimeError(e)')] Could that be a Mobile Safari thing?

Yeah it's sad apple has crippled their browser the browser on a $40 android tablet is more powerful than safari running on a $1200 iPhone

It fails on other browsers as well (e.g. Firefox on Linux) and someone has discovered[1] that it may well be a Netlify bug (sending more data than it's supposed to). I agree with your point that that Apple could do better but in this case it does seem that Apple's browser is doing the right thing and ignoring invalid data provided by Netlify (which is the same behaviour as Firefox at the very least). In any case going direct[2] to GitHub should work fine--that link works for me in Firefox on Linux (whereas the Netlify one does not).

[1]: https://news.ycombinator.com/item?id=28016906 [2]: https://phiresky.github.io/blog/2021/hosting-sqlite-database...

Re: Hosting SQLite Databases on GitHub Pages

#29
post #27

SQLite not being in browsers instead of indexdb saddens me today still. I designed a system 15 years ago that released dimensional star schemas for specific reports as sqllite databases into Adobe Air (or whatever the prerelease name was) for a large retailer in the UK. We would query the data warehouse, build the sqlite db file (I can't remember the exact db sizes but they weren't too big - 15mb or so) and the compu…

You actually can use SQLite on some browsers with WebSQL today. Unfortunately, WebSQL has been deprecated and is already removed from some browsers ( https://softwareengineering.stackexchange.com/questions/2202... ).

Oh man, that's a shame. I remember looking into WebSQL when I was designing a little Phonegap tourist app, and ended up just using localstorage instead, like this guy, but I tucked it away as a possible technology for some use case I never quite got around to. SQLite is great and it doesn't make any sense to deprecate WebSQL in favor of some key/value "nosql db" pattern, since there are already plenty of other alternatives for storing nonrelational data.
Post reply on HN