sqldelight-sqlite-wasm icon indicating copy to clipboard operation
sqldelight-sqlite-wasm copied to clipboard

Example broken

Open Burtan opened this issue 1 year ago • 3 comments

Hey, I tried your example, however it does not work, currently (Linux firefox and chrome). https://dellisd.github.io/sqldelight-sqlite-wasm/

sqlite3.js:9978 Ignoring inability to install OPFS sqlite3_vfs: This environment does not have OPFS support.

(anonymous) @ sqlite3.js:9978 CoroutineExceptionHandlerImpl.kt:11 Gcause: undefinedmessage: "{\"message\":\"sqlite result code 1: no such vfs: opfs\",\"name\":\"Error\"}"name: "G"stack: "G: {\"message\":\"sqlite result code 1: no such vfs: opfs\",\"name\":\"Error\"}\n at R.tx (https://dellisd.github.io/sqldelight-sqlite-wasm/sqldelight-sqlite-wasm.js:1:315503)\n at R.handleEvent (https://dellisd.github.io/sqldelight-sqlite-wasm/sqldelight-sqlite-wasm.js:1:315653)"[[Prototype]]: Errorconstructor: ƒ G(t)[[Prototype]]: Object fe @ CoroutineExceptionHandlerImpl.kt:11

Burtan avatar Feb 28 '23 07:02 Burtan

Ah, I guess OPFS is currently only available on a small subset of browsers.

Burtan avatar Mar 01 '23 16:03 Burtan

Ah yes, part of the issue is that only a few browsers currently support OPFS to the degree that SQLite needs (I think Chromium-based ones are the only ones to date).

The other problem is that OPFS requires the site/scripts to be loaded with certain headers, which unfortunately can't be done on GitHub pages so that live demo will never work. I'll probably set up a proper live demo eventually, but for now I'm going to remove that link.

dellisd avatar Mar 02 '23 16:03 dellisd