Compile sqlx (sqlite) for wasm32

[nicolas-albert]

Hi,
I discovered your crate and it seems well designed.

I'm thinking about a data abstraction library over SQL that could run in an application written in Rust, in Java (JNI) but also in Web (compiled to WASM and store data in a local client database, like sqlite).

I haven't tested the compilation in JNI but I don't worry.

--target wasm32-unknown-unknown compilation fails due to runtime (tokio or async-std).
Other runtime dependent crate are wasm32 compatible, such as reqwest.

Then I tried to compile the crate sqlite and this time, it's an error specific to sqlite that does not pass (no <pthread.h>).

In the end, I tried to compile the crate rusqlite successfully. They managed to modify their project to compile in wasm32.

I could use rusqlite for the wasm version and sqlx for the others (and benefit from all connectors) but it could be more clean to only use the sqlx api.

There remains the persistence of sqlite in a local database. The sqlite ports in wasm (not using Rust) use memory storage.
Except absrude-sql and wa-sqlite which allow an implementation of VFS on IndexedDB with performances that seem very correct.

It looks like a big project with several problems to solve that have been solved elsewhere:

1. a wasm-compatible runtime
2. an sqlite mode that compiles to wasm
3. sqlite persistence in IndexedDB

sqlx seems really complete and the support of these technologies could open new development horizons.

[seanaye]

Has anyone tried to get this working with any success? I think there is a lot of potential for wasm on the edge and a connection to something like https://chiselstrike.com/

[thangchung]

I saw WasmEdge forked sqlx repo, and tried to add capability for wasi => https://github.com/WasmEdge/sqlx, but I haven't tested on my machine yet

[tadghh]

Im about to switch over to https://github.com/gluesql/gluesql it might be a good replacement for anyone else hitting this wall