sql-wasm.wasm file is not loaded by sql-wasm.js file

[fpassa]

By using the:

<script src="assets/sql-wasm.js"></script>

in my index.html of ionic app, I get the following error indicating that sql-wasm.js cannot load the wasm.wasm file even thought I've added both files in same folder "www/assets"

This is the console output:
VM16478 polyfills.js:3514 GET http://localhost:8100/sql-wasm.wasm 404 (Not Found)
(anonymous) @ VM16478 polyfills.js:3514
push../node_modules/zone.js/dist/zone.js.ZoneDelegate.scheduleTask @ VM16478 polyfills.js:2772
onScheduleTask @ VM16478 polyfills.js:2663
push../node_modules/zone.js/dist/zone.js.ZoneDelegate.scheduleTask @ VM16478 polyfills.js:2766
push../node_modules/zone.js/dist/zone.js.Zone.scheduleTask @ VM16478 polyfills.js:2600
push../node_modules/zone.js/dist/zone.js.Zone.scheduleMacroTask @ VM16478 polyfills.js:2623
(anonymous) @ VM16478 polyfills.js:3509
ZoneAwarePromise @ VM16478 polyfills.js:3272
global.fetch @ VM16478 polyfills.js:3508
mb @ VM16476 sql-wasm.js:107
f.asm @ VM16476 sql-wasm.js:108
(anonymous) @ VM16476 sql-wasm.js:159
ZoneAwarePromise @ VM16478 polyfills.js:3272
initSqlJs @ VM16476 sql-wasm.js:22
r.onload @ VM16481 main.js:1105
push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invoke @ VM16478 polyfills.js:2753
onInvoke @ VM16480 vendor.js:51342
push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invoke @ VM16478 polyfills.js:2752
push../node_modules/zone.js/dist/zone.js.Zone.runGuarded @ VM16478 polyfills.js:2523
(anonymous) @ VM16478 polyfills.js:2506
load (async)
set @ VM16478 polyfills.js:3864
(anonymous) @ VM16481 main.js:1103
ZoneAwarePromise @ VM16478 polyfills.js:3272
push../src/app/services/db-service.ts.DbService.setDBFile @ VM16481 main.js:1100
push../src/app/tab2/tab2.page.ts.Tab2Page.openDatabase @ VM16756 tab2-tab2-module.js:126
(anonymous) @ VM16758 Tab2Page.ngfactory.js:53
handleEvent @ VM16480 vendor.js:57150
callWithDebugContext @ VM16480 vendor.js:58220
debugHandleEvent @ VM16480 vendor.js:57947
dispatchEvent @ VM16480 vendor.js:54599
(anonymous) @ VM16480 vendor.js:55046
(anonymous) @ VM16480 vendor.js:66909
push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask @ VM16478 polyfills.js:2785
onInvokeTask @ VM16480 vendor.js:51333
push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask @ VM16478 polyfills.js:2784
push../node_modules/zone.js/dist/zone.js.Zone.runTask @ VM16478 polyfills.js:2557
push../node_modules/zone.js/dist/zone.js.ZoneTask.invokeTask @ VM16478 polyfills.js:2860
invokeTask @ VM16478 polyfills.js:4106
globalZoneAwareCallback @ VM16478 polyfills.js:4132
VM16476 sql-wasm.js:107 wasm streaming compile failed: TypeError: Failed to execute 'compile' on 'WebAssembly': HTTP status code is not ok

[lovasoa]

It looks like you did not load the module with the right options. Please read the README. You probably did not specify the path to the wasm file correctly. The initSqlJs function takes a configuration object with a locateFile property.

What you need is probably

initSqlJs({locateFile: filename => `/assets/${filename}`})

[TomasHubelbauer]

For JsDelivr users landing here:

initSqlJs({
    locateFile: name => 'https://cdn.jsdelivr.net/npm/sql.js@1.0.0/dist/' + name
})