Jan Vaillant

It turned out that we do not desperately need sparse arrays right now. With our current model/data we stay below a "critical" size (wherever that is) with our indices. But...

Hi, I am afraid no. It needs to be included during compilation. Also I am not sure about the quality of this extension: It is not an official sqlite extension....

> Hi, thanks for reply, do you have any plans to add **loadExtension** api ? I think - at least to my current understanding - this is impossible because WebAssembly...

@spaciandd Please checkout the new version. I'll pin this issue and rename it so I can reuse it for other extensions.

Would be nice to have a **synchronous** api to access to files in a way that allows open/read/write/close (as mentions here https://github.com/tauri-apps/tauri/issues/1025) to directly read/write large files without copying them...

> A synchronous api is not possible, but I will add nodejs async function `open` which returns a `FileHandle` class Sorry, a bit off-topic but Is that a design decision...

Thank you for your thoughts and insight, but ... > This is difficult in the current design because we use message passing to communicate with the WebView, meaning Rust loads...

Just an idea: I played a little bit with SQLite's sqlite3_vfs and sql.js: it is possible to implement a custom vfs and register, use it in sql.js. I tried it...

@Hao-Yan AS far as I remember it works just fine in node if you mount the file system. I have not tried it in the browser yet.

Hi @seb2010, would you like to prepare a PR? Maybe as an optional output.