wasm_sqlite_with_stats
wasi-sqlite
| wasm_sqlite_with_stats | wasi-sqlite | |
|---|---|---|
| 3 | 3 | |
| 24 | 6 | |
| - | - | |
| 10.0 | 0.0 | |
| over 1 year ago | almost 2 years ago | |
| C | C | |
| MIT License | - |
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_with_stats
-
SQLite Release 3.40.0
Not by default, you can test it out here[1].
I documented how to compile an extension into the wasm build here[2], I assume something like that would work for fts? But I'm not sure exactly.
[1]: https://sqlite.org/fiddle/
[2]: https://github.com/llimllib/wasm_sqlite_with_stats/tree/buil...
-
SQLite WASM Official
I wrote up how to compile SQLite to WASM and also include an extension: https://github.com/llimllib/wasm_sqlite_with_stats
You can play with the wasm-compiled extension at the version of the sandbox I compiled here: https://llimllib.github.io/wasm_sqlite_with_stats/
I tried to be thorough with the writeup, so hopefully it helps somebody if that's something they need.
-
I Figured out How to Build SQLite into WASM And Include Extensions
I put thorough instructions here because it wasn't documented anywhere that I could find.
wasi-sqlite
-
SQLite 3.40.0 with WASM Support
I hacked a bit of that in here: https://github.com/rcarmo/wasi-sqlite
Right now I can run SQLite on my iPad under a-Shell pretty well, but there seems to be a bug in the REPL (not sure where) and memory usage skyrockets.
Would love to see this working in a CLI environment.
-
SQLite WASM Official
Very nice. I built sqlite3 for WASI/a-Shell to use on my iPad (https://github.com/rcarmo/wasi-sqlite) and it still has a few issues, I hope this will help (although right now the biggest issue seems to be that the REPL has some sort of memory leak when run inside WASI).
- Rcarmo/wasi-SQLite: sqlite3 CLI for a-Shell on iOS
What are some alternatives?
vaxine - Rich-CRDT database based on AntidoteDB.
kikko - Powerful SQLite adapter for web, mobile and desktop. Build reactive UI on top of it
evolu - Local-first platform designed for privacy, ease of use, and no vendor lock-in
examples - Example applications using ElectricSQL.
cowasm - CoWasm: Collaborative WebAssembly for Servers and Browsers. Built using Zig. Supports Python with extension modules, including numpy.
cr-sqlite - Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite
datasette-lite - Datasette running in your browser using WebAssembly and Pyodide