sql.js | vaxine | |
---|---|---|
1 | 2 | |
118 | 109 | |
- | 0.0% | |
10.0 | 10.0 | |
about 4 years ago | over 1 year ago | |
Erlang | ||
- | 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.
sql.js
-
SQLite WASM Official
SQLite was one of the first large C code bases to be ported to the web. Alon Zakai (@kripken, the creator of emscripten), made the first commit to sql.js at the start of 2012 [0]. I got involved two years later, and have been maintaining sql.js since. A lot was added since 2012, but the initial core api with 3 functions 'open', 'exec', and 'close' still works today.
https://github.com/kripken/sql.js/commit/cebd80648dbd369b348...
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
What are some alternatives?
kikko - Powerful SQLite adapter for web, mobile and desktop. Build reactive UI on top of it
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
electric_dart - A Dart implementation for Electric (electric-sql.com).
examples - Example applications using ElectricSQL.
wasi-sqlite - sqlite3 CLI for a-Shell on iOS
EteSync Server - The Etebase server (so you can run your own)
RxDB - A fast, local first, reactive Database for JavaScript Applications https://rxdb.info/