wasm-sqlite VS workers-wasi

Compare wasm-sqlite vs workers-wasi and see what are their differences.

wasm-sqlite

[Experimental] SQLite compiled to WASM with pluggable page storage. (by rkusa)
Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
wasm-sqlite workers-wasi
1 5
47 119
- 1.7%
0.0 0.0
about 1 year ago about 1 year ago
Rust C++
- BSD 3-clause "New" or "Revised" License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

wasm-sqlite

Posts with mentions or reviews of wasm-sqlite. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-01-26.
  • Store SQLite in Cloudflare Durable Objects
    14 projects | dev.to | 26 Jan 2022
    The whole code can be found here: github.com/rkusa/wasm-sqlite/blob/main/wasm/src/vfs.rs. By reducing all down to the two methods get_page and put_page (to which I get back later in the post), the VFS ended up being a generic VFS for when you want to persist SQLite pages as separate files/objects. Using it anywhere else than a DO would just be a matter of providing a different implementation to those two methods.

workers-wasi

Posts with mentions or reviews of workers-wasi. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-11-15.
  • WASM by Example
    16 projects | news.ycombinator.com | 15 Nov 2023
    The examples seemed clear enough to read (I did not test them), but I felt than even when teaching by example there needs to be more overview and explanation. I.e., I would prefer an overview of WASM structure and use with examples, rather than just the examples. (I have some (but limited) experience using WASM.)

    As for the utility of wasm, note also that Cloudflare workers can run WASM on edge servers [1], and that the Swift community has some support for compiling to wasm [2].

    I've never really understood how wasm could do better than java bytecode, but I've been impressed with how much people are using lua and BPF. More generally, in a world of federated programming, we need languages client can submit that providers can run safely, without obviously leaking any secret sauce -- perhaps e.g., for model refinement or augmented lookup.

    [1] https://github.com/cloudflare/workers-wasi

  • SQLite builds for WASI since 3.41.0
    5 projects | news.ycombinator.com | 24 May 2023
    Those are great questions! I believe Emscripten will be required for some cases as it provides more features for targeting a Web Browser. If WASI is the only requirement for a Wasm module, then there are three possible solutions:

    - Use a library that provides the WASI bindings in a browser environments: there are some OSS projects that provides WASI bindings on top of browser technologies. For example, workers-wasi from Cloudflare [1]. It could be even another Wasm module that provides the implementation for the main one. I know the people from Loophole Labs are experimenting with virtual filesystems (VFS) [2].

    - Browsers provides a WASI implementation: server-oriented runtimes like NodeJS are already providing these bindings (under a experimental flag). I shouldn't have stated that as a fact, as browsers may provide it or not. However, I saw in the past the Google Chrome team experimenting with WASI and the browser FileSystem API [3]. So, I think it may happen :)

    - [1] https://github.com/cloudflare/workers-wasi

    - [2] https://www.youtube.com/watch?v=46jZSXVxYPw

    - [3] https://github.com/GoogleChromeLabs/wasi-fs-access

  • The Tug-of-War over Server-Side WebAssembly
    12 projects | news.ycombinator.com | 24 Mar 2023
    Indeed, some people are doing this:

    - WASI once had an official polyfill https://wasi.dev/polyfill/, now apparently succeeded by https://github.com/bjorn3/browser_wasi_shim

    - wasmer-js provides a JS polyfill for WASI https://docs.wasmer.io/integrations/js/wasi

    - Cloudflare has a WIP polyfill https://github.com/cloudflare/workers-wasi

    I'm generally leery of non-temporary polyfills, so I'm not sure that any of these feel like a long-term viable option for me.

  • Rust advocacy at a medium-sized startup
    2 projects | news.ycombinator.com | 19 Jun 2022
    I think modern C++ could be perfectly viable as well. Maybe https://github.com/cloudflare/workers-wasi would be a good starting point? I'm not too knowledgeable on the subject. Exciting times though, I think WASM might be the great equalizer.
  • Store SQLite in Cloudflare Durable Objects
    14 projects | dev.to | 26 Jan 2022
    While there is a WASI implementation for Workers: cloudflare/workers-wasi, I prefer to implement each import manually - especially when there are so few and especially while I am still experimenting. This helps me to keep the full picture of what's going on.

What are some alternatives?

When comparing wasm-sqlite and workers-wasi you can also consider the following projects:

rusqlite - Ergonomic bindings to SQLite for Rust

workers-rs - Write Cloudflare Workers in 100% Rust via WebAssembly

sqlite-vfs - Build SQLite virtual file systems (VFS) by implementing a simple Rust trait.

asyncify - Standalone Asyncify helper for Binaryen

wasi-sdk - WASI-enabled WebAssembly C/C++ toolchain

binaryen - Optimizer and compiler/toolchain library for WebAssembly

rusqlite - Ergonomic bindings to SQLite for Rust

do-sqlite - [Experimental] Persist SQLite in a Cloudflare Durable Object

wasi-libc - WASI libc implementation for WebAssembly

wasm-bindgen - Facilitating high-level interactions between Wasm modules and JavaScript