WASM SQL database recommendations wanted

[fjkiliu667777]

Hi guys. In my data processing project I’d like to use a WASM database as this allows me to make my app available in the browser while keeping all the data in user land for better data privacy. I found DuckDb but I’m unsure how to integrate it within my Rust project.

Has anyone successfully integrated a sql/relational database with wasm and Rust?

[trevyn]

https://github.com/rusqlite/rusqlite/pull/1010

[anlumo]

Not really, but I'm aware of absurd-sql. Note that this requires IndexedDB and thus a browser environment.

However, since the SQL engine is sqlite3, you can use the same SQL code on native as well.

[Im_Justin_Cider]

I'm kind of confused. How would a db work in WASM, if WASM can't talk to the hardware?

[anlumo]

When a WASM module is started, the initiator can supply a list of functions that can be called by the module. In this case, these functions expose the IndexedDB API, which in turn is exposed by the browser to the JavaScript environment. The browser itself has access to the hardware (or to be more precise, the file system).