vaxine
wasi-sqlite
vaxine | wasi-sqlite | |
---|---|---|
2 | 3 | |
109 | 6 | |
0.0% | - | |
10.0 | 0.0 | |
about 1 year ago | almost 2 years ago | |
Erlang | C | |
Apache License 2.0 | - |
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.
vaxine
-
Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps
Hi HN, James, Valter, Sam and the team from ElectricSQL here.
We're really excited to be sharing ElectricSQL with you today. It's an open source, local-first sync layer that can be used to build reactive, realtime, offline-capable apps directly on Postgres with two way active-active sync to SQLite (including with WASM in the browser).
Electric comprises a sync layer (built with Elixir) placed in front of your Postgres database and a type safe client that allows you to bidirectionally sync data from your Postgres to local SQLite databases. This sync is CRDT-based, resilient to conflicting edits from multiple nodes at the same time, and works after being offline for extended periods.
Some good links to get started:
- website: https://electric-sql.com
- docs: https://electric-sql.com/docs
- code: https://github.com/electric-sql/electric
- introducing post: https://electric-sql.com/blog/2023/09/20/introducing-electri...
You can also see some demo applications:
- Linear clone: https://linear-lite.electric-sql.com
- Realtime demo: https://electric-sql.com/docs/intro/multi-user
- Conflict-free offline: https://electric-sql.com/docs/intro/offline
The Electric team actually includes two of the inventors of CRDTs, Marc Shapiro and Nuno PreguiƧa, and a number of their collaborators who've pioneered a lot of tech underpinning local-first software. We are privileged to be building on their research and delighted to be surfacing so much work in a product you can now try out.
- SQLite WASM Official
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?
electric - Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.
wasm_sqlite_with_stats - Documentation and demonstration of how to build WASM versions of SQLite with extensions embedded
evolu - Local-first platform designed for privacy, ease of use, and no vendor lock-in
cr-sqlite - Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite
cowasm - CoWasm: Collaborative WebAssembly for Servers and Browsers. Built using Zig. Supports Python with extension modules, including numpy.
kikko - Powerful SQLite adapter for web, mobile and desktop. Build reactive UI on top of it
examples - Example applications using ElectricSQL.
electric_dart - A Dart implementation for Electric (electric-sql.com).