Wasm LinkError when trying to use SQLite in Ionic 8/Angular/Capacitor app

[MarconiArte]

Hello, I'm still encountering these Wasm-related errors. Previously, I resolved them by downgrading jeep-sqlite and sql.js dependencies, but the issue has reappeared. I've now updated to the latest stable versions without success.

  "scripts": {
    "ionic:serve:before": "npm run copy:sql:wasm",
    "copy:sql:wasm": "copyfiles -u 3 node_modules/sql.js/dist/sql-wasm.wasm src/assets",
  },

"dependencies": {
  "@capacitor-community/sqlite": "^7.0.0",
  "jeep-sqlite": "^2.8.0",
  "sql.js": "^1.13.0"
}

capacitor.config.ts:

CapacitorSQLite: {
			iosDatabaseLocation: 'Library/CapacitorDatabase',
			iosIsEncryption: true,
			iosKeychainPrefix: 'angular-sqlite-app-starter',
			iosBiometric: {
				biometricAuth: false,
				biometricTitle: "Biometric login for capacitor sqlite"
			},
			androidIsEncryption: true,
			androidBiometric: {
				biometricAuth: false,
				biometricTitle: "Biometric login for capacitor sqlite",
				biometricSubTitle: "Log in using your biometric"
			}
		},

REF: https://jepiqueau.github.io/2023/08/26/Ionic7Angular-SQLite-CRUD-App.html#update-angularjson

[lydongray]

Did you have any luck with this @MarconiArte? I'm trying to upgrade to the latest version of @capacitor-community/sqlite as well, which at the time of writing is v7.0.1. The example that uses @capacitor-community/[email protected] works great, but after upgrading to v6 or v7, I get the error above. Forcing sql.js to v1.11.0 fixes the error but then stops reading and writing (without error) for whatever reason.

[lydongray]

So based on your (@MarconiArte) suggestion to downgrade jeep-sqlite and sql.js, I installed jeep-sqlite v2.5.2 and sql.js v1.8.0 and the application works great with the latest version of @capacitor-community/sqlite v7.0.1. Sqlite storage is now working in the web and on Android, HOWEVER, it is not working on iOS.

The error I get now when using @capacitor-community/sqlite v7.0.1 is '"CapacitorSQLite" plugin is not implemented on ios'. It didn't work for @capacitor-community/sqlite v6 either, but I didn't check the logs in the case of v6 so I'll assume the same error.

The only discernable difference I can see is the change to the Podfile.lock file, which is simply defining the new versions of @capacitor and @capacitor-community/sqlite. I will continue this grueling process and hopefully come up with a solution!!