Support for WASM target

[kdabir]

Is WASM as target platform on the roadmap? WASM along with OPFS using sqlite-wasm library should make it quite usable.

[qiaoyuang]

Hi, that's a good idea, I would consider and research it. But I am inexperienced in WASM area, So, maybe I need some time. If I have any progress, I will update it in this issue. I have checked out a new brunch dev-wasm, if you want to submit PRs, I am also very welcome.

[qiaoyuang]

Hi @kdabir . I have tried to support Kotlin/WASM target, but I found some problems. For example, I use this way: implementation(npm("sqlite-wasm", "3.41.2")) to import SQLite WASM NPM package to sqllin-driver, but it didn't work, and it is very hard to solve. So, maybe we can wait Kotlin/WASM be more mature, and make SQLlin support it at that time.

[vdshb]

It looks like sqlite-wasm implementation was evolving and stabilizing since mid-2023 (mostly until mid-2024). Kotlin/WASM is still unstable here and there, though. Maybe trying to implement Kotlin/js (pretty stable) with sqlite-wasm worker from fresh npm-package might be a reasonable alternative/start.

[qiaoyuang]

@vdshb You're right. I'll try it when I have time.