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?
Hosting SQLite Databases on GitHub Pages
21–30 of 82 posts
Re: Hosting SQLite Databases on GitHub Pages
#22Wow okay, so is this like an HTTP based buffer pool manager? Instead of reading pages from disk it reads via HTTP?
Re: Hosting SQLite Databases on GitHub Pages
#23Re: Hosting SQLite Databases on GitHub Pages
#24Earlier 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.
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
#25Good 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
Re: Hosting SQLite Databases on GitHub Pages
#26I 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
#27SQLite 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…
Re: Hosting SQLite Databases on GitHub Pages
#28Good 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
[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
#29SQLite 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... ).