Sqlite3 WebAssembly

1. wasi-libc

   1 53 876 7.9 C

   WASI libc implementation for WebAssembly

   

   https://wasi.dev/

   wow I didn't know this was a thing. thanks for filling me in!

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. go-sqlite3

   2 29 569 9.6 Go

   Go bindings to SQLite using wazero (by ncruces)

   

   For server side, you'll likely need a different build of Wasm SQLite, that handles concurrency (and file locking) differently.

   Also, WASI is very far from answer (so far). The SQLite amalgamation builds fine for WASI but concurrency is an unsolved issue.

   I had to build a VFS from scratch to get my Wasm based SQLite driver into a usable shape.

   https://github.com/ncruces/go-sqlite3/blob/main/vfs/README.m...

4. wa-sqlite

   3 11 975 9.1 JavaScript

   WebAssembly SQLite with support for browser storage extensions

   

   I have been working on one. If you're interested in working on it or contributing, feel free to chime in here:

   https://github.com/rhashimoto/wa-sqlite/discussions/154

   This essentially requires that we import the sqlite emscripten build via an extern C header in wasm bindgen, and then we need to re-implement the VFS in rust while compiling it in multi-threaded mode to allow for shared array buffer access. After that is all done, we will be able to access SQLite rows as raw wasm bytes. That gives us the ability to implement a rust-sqlite style wrapper or integration. There would still not be some of the niceties such as connection pooling, but in wasm you likely want to use the db in exclusive mode.

5. sqlite-web-rs

   4 2 28 6.4 Rust

   A SQLite WebAssembly backend for Diesel

   

   Got this SQLite build working with rusts diesel sqlite here: https://github.com/xmtp/diesel-wasm-sqlite

   I'm gearing up for a 0.2 release this week which should iron out a few kinks, but otherwise you can use the diesel ORM as if its native

6. sqlite-wasm

   5 2 682 7.1 JavaScript

   SQLite Wasm conveniently wrapped as an ES Module.

   

7. pglite

   6 28 10,227 9.4 TypeScript

   Lightweight WASM Postgres with real-time, reactive bindings.

   

   See also https://github.com/electric-sql/pglite.

   (Previously discussed 7 months ago: https://news.ycombinator.com/item?id=39477457)

8. duckdb-sqlite

   7 5 223 7.3 C

   DuckDB extension to read and write to SQLite databases

   

   You can use DuckDB WASM independently of Pyodide and can extend it with SQLite.

   Though it seems to be somewhat limited. I couldn't even check what version it has, since sqlite_version() was missing. Version in the repository [1] is 3.38.1, which is from quite a ways ago.

   At the moment DuckDB web shell can't load SQLite extension, since that hasn't been released for yesterday's 1.1.2. Earlier version does work using recently updated WASM edition. That can be extended with spatial including GDAL, vector search etc [2]. Making your own "SQL web shell" wasn't too hard, though docs weren't quite complete enough for me.

   [1] https://github.com/duckdb/sqlite_scanner/blob/main/src/sqlit...

9. duckdb-wasm

   8 17 1,398 9.2 TypeScript

   WebAssembly version of DuckDB

   

10. sqlite-wasm-http

    9 2 87 9.0 TypeScript

    An experimental HTTP VFS driver for SQLite WASM

    

    Personally I'm using it for a statically hosted website, so a server-hosted database was never an option. Also with the right driver, it's possible to stream the chunks of the DB as needed rather than sending the full database.

    https://github.com/mmomtchev/sqlite-wasm-http

11. jsr

    10 21 2,601 9.4 Rust

    The open-source package registry for modern JavaScript and TypeScript

    

    If you like, solving these sort of problems, we are tackling them at Fireproof.

    Our database API is modeled on CouchDB and MongoDB, but our storage abstractions are along the lines of what you need to build the multi writer WAL you describe.

    More details here https://jsr.io/@fireproof/encrypted-blockstore

12. orbitdb

    11 34 8,402 8.1 JavaScript

    Peer-to-Peer Databases for the Decentralized Web

    

13. litevfs

    12 2 55 8.9 Rust

    LiteFS VFS SQLite extension for serverless environments

    

    LiteVFS can be compiled in a browser and sync with LiteFS cloud: https://github.com/superfly/litevfs

    It needs to be run from a worker, though

14. wasm-bindgen

    13 50 7,998 9.6 Rust

    Facilitating high-level interactions between Wasm modules and JavaScript

    

    > I couldn't figure out a way to to get emscripten wasm code to play nice with wasm32-unknown-unknown

    There is good news there, some people plan to work on making Emscripten and Rust work well in Wasm:

    https://github.com/rustwasm/wasm-bindgen/pull/4014#issuecomm...

15. sqlsync

    14 11 2,440 9.2 Rust

    SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.

    

    I believe that streaming changes from SQLite is what https://sqlsync.dev/ is

16. django_webassembly

    15 2 15 10.0 Python

    I didn't fully understand this idea of hydration but I also got recently interested in leveraging Wasm, in context of running parts of backend logic using it (eg. regular templating and some Htmx endpoints) to allow certain offline features with regular server-side web frameworks that could use similar Sqlite Wasm datastore as OP.

    - Full Django example https://github.com/m-butterfield/django_webassembly

17. sqlighter

    16 3 - -

    Shameless plug for the fastest way to get the serverdata to the client: just send data in the format that sqlite itself uses: https://gitlab.com/sander-hautvast/sqlighter (available in java and rust, no dependencies on sqlite itself). This works well with the wasm build. The java project contains a demo that also shows how to setup the UI code.

Suggest a related project