Hacker GitHub

← All repos

vlcn-io/cr-sqlite

View on GitHub ↗ ★ 3,823 Rust

Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite

36 mentions on Hacker News by 24 people: 2 stories, 34 comments · first 2022-11-15 · latest 2026-07-14

Mentions per year 36 mentions · busiest year 2023 (19)
20082026
AllStoriesComments NewestTopOldest
  1. …vlcn-io/cr-sqlite: Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite https://github.com/vlcn-io/cr-sqlite Notes on sandboxing agents: amla sandbox, agentvm, bwrap at least; debugging mcp servers, and signing agent…
    comment by westurner · 2026-07-14 · in Show HN: Juggler – an open-source GUI coding agent, by the creator of JUCE
  2. …together. There is a limit on how many databases you can attach together in a session though. [1]: https://github.com/vlcn-io/cr-sqlite [2]: https://sqlite.org/lang_attach.html
    comment by benbjohnson · 2026-02-04 · in Litestream Writable VFS
  3. …the field values as far as I understand. There is a comment mentioning it could be optimized away: https://github.com/vlcn-io/cr-sqlite/blob/891fe9e0190dd20917...
    comment by ricardobeat · 2025-10-27 · in Corrosion
  4. Does this have any relation to: https://github.com/vlcn-io/cr-sqlite ? Some of the API naming is similar (db_version, site_id, seq, commit_alter, etc), although the project source is very different (C rather than Rust, different feature…
    comment by mjadobson · 2025-08-07 · in SQLite offline sync for Android quick start
  5. Thank you Ben for the great work on this project! Also, I remember looking into this one and: https://github.com/vlcn-io/cr-sqlite/issues/444
    comment by j0e1 · 2025-05-20 · in Litestream: Revamped
  6. …use cases. If you're interested in local-first, you can check out projects like cr-sqlite[1]. [1]: https://github.com/vlcn-io/cr-sqlite
    comment by benbjohnson · 2025-05-20 · in Litestream: Revamped
  7. cr-sqlite https://github.com/vlcn-io/cr-sqlite : > Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite From "SQLedge: Replicate Postgres to SQLite on the Edge" (2023) https://news.ycombinator.com/item?id=37063238#3706798…
    comment by westurner · 2024-07-20 · in Automerge: A library of data structures for building collaborative applications
  8. …you could drop into an existing project very easily Personally, I've been pretty happy with https://github.com/vlcn-io/cr-sqlite/ which is just a sqlite extension that can run in the browser.
    comment by AlexErrant · 2024-06-25 · in Show HN: Triplit – Open-source syncing database that runs on server and client
  9. How does this compare to cr-sqlite ( https://github.com/vlcn-io/cr-sqlite ) which uses CRDTs to create a conflict free replicated sqlite?
    comment by snthpy · 2024-06-11 · in SQLSync: A collaborative offline-first wrapper around SQLite
  10. …If you ever feel like moving beyond the Apple market you might look into https://github.com/vlcn-io/cr-sqlite I've been using it in my own Anki-clone and am very happy with it.
    comment by AlexErrant · 2024-04-08 · in Show HN: Flash Notes – Flashcards for Your Notes, LLM, iOS/macOS Sync
  11. …could benefit from getting to know these things. [1] https://rxdb.info/ [2] https://crdt.tech/ [3] https://github.com/vlcn-io/cr-sqlite
    comment by textinterface · 2024-03-30 · in You can't leak users' data if you don't hold it
  12. I'm a happy user of https://github.com/vlcn-io/cr-sqlite/
    comment by AlexErrant · 2024-01-13 · in Show HN: RemoteStorage – sync localStorage across devices and browsers
  13. …a Rust-based loadable extension that adds CRDT changeset generation and reconciliation to SQLite: https://github.com/vlcn-io/cr-sqlite Slightly related but not really (no multi writer, no C-level SQLite API or other restrictions): - comdb2…
    comment by summarity · 2023-12-11 · in Marmot: Multi-writer distributed SQLite based on NATS
  14. …working on tender about a year ago. If I were starting now instead of a year prior, I might try to go with github.com/vlcn-io/cr-sqlite which seems to share ideals with my architecture, and automerge has some issues I've run into.
    comment by stpn · 2023-12-04 · in Show HN: I built an inbox-zero expense tracker with CRDTs and SQLite in browser
  15. Also https://github.com/vlcn-io/cr-sqlite/ which is SQLite + CRDTs Runs/syncs to the browser too which is just lovely.
    comment by AlexErrant · 2023-10-02 · in Local-first software: You own your data, in spite of the cloud (2019)
  16. …the same process (so no network overhead) but still guarantee converge to the same state. [1] https://github.com/vlcn-io/cr-sqlite
    comment by matlin · 2023-09-22 · in I'm all-in on server-side SQLite (2022)
  17. …it; can truly decouple the migration's write load from the master's workload. #. vlcn-io/cr-sqlite: https://github.com/vlcn-io/cr-sqlite : > Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite > CR-SQLite is a run-time…
    comment by westurner · 2023-08-09 · in SQLedge: Replicate Postgres to SQLite on the Edge
  18. …as I know the transactions of Yjs seem to be a problem on heavily changing documents. Thanks! [1] https://github.com/vlcn-io/cr-sqlite#approach-1-history-free...
    comment by patrickbaber · 2023-08-02 · in Launch HN: Tiptap (YC S23) – Toolkit for developing collaborative editors
  19. I wouldn't say no to first-party integration with crsqlite! [1] [1] https://github.com/vlcn-io/cr-sqlite
    comment by aarpmcgee · 2023-08-02 · in Launch HN: Tiptap (YC S23) – Toolkit for developing collaborative editors
  20. …You may want to look at either vlcn[1] or Mycelite[2] as options for doing that approach. [1]: https://github.com/vlcn-io/cr-sqlite [2]: https://github.com/mycelial/mycelite
    comment by benbjohnson · 2023-07-05 · in LiteFS Cloud: Distributed SQLite with Managed Backups
  21. I haven't personally but typically people use a CRDT-based approach like vlcn[1] or Mycelite[2]. [1]: https://github.com/vlcn-io/cr-sqlite [2]: https://github.com/mycelial/mycelite
    comment by benbjohnson · 2023-07-05 · in LiteFS Cloud: Distributed SQLite with Managed Backups
  22. …the best closed source solution I know of. [1] - https://github.com/rhashimoto/wa-sqlite [2] - https://github.com/vlcn-io/cr-sqlite [3] - https://replicache.dev/
    comment by maccaw · 2023-06-29 · in Scaling Linear's Sync Engine
  23. …clone I'm building [5] and have only positive things to say about cr-sqlite and its maintainer. [0] https://github.com/vlcn-io/cr-sqlite/ [1] https://github.com/rhashimoto/wa-sqlite/ [2] https://github.com/rhashimoto/wa-sqlite/discussions/6…
    comment by AlexErrant · 2023-06-26 · in Mycelite: SQLite extension to synchronize changes across SQLite instances
  24. …wrote a SQLite extension that gives it CRDT semantics! It's a CRDT-Sqlite or ... CR-Sqlite. Ha. https://github.com/vlcn-io/cr-sqlite
    comment by toomim · 2023-05-19 · in CRDT-richtext: Rust implementation of Peritext and Fugue
  25. Very cool. Left some comments related to some drawbacks I see of your current approach -- https://github.com/vlcn-io/cr-sqlite/issues/65#issuecomment-... If you're open to resolving those I'd love to stick it into cr-sqlite :)
    comment by tantaman · 2023-05-18 · in CRDT-richtext: Rust implementation of Peritext and Fugue
  26. Yeah, I would rather have Peritext inside of SQLite itself: https://github.com/vlcn-io/cr-sqlite
    comment by conradev · 2023-05-18 · in CRDT-richtext: Rust implementation of Peritext and Fugue
  27. The linked projects ( https://vlcn.io and https://github.com/vlcn-io/cr-sqlite ) are both extremely impressive, and open up the possibility of adding "multiplayer" to apps that rely on SQLite for local storage—including web apps, via a…
    comment by turnsout · 2023-02-11 · in A Gentle Introduction to CRDTs
  28. …[1] https://observablehq.com/@asg017/introducing-sqlite-path#cel... [2] https://github.com/vlcn-io/cr-sqlite [3] https://github.com/asg017/sqlite-loadable-rs/issues/5
    comment by alexgarcia-xyz · 2023-02-06 · in Making SQLite extensions pip install-able
  29. …a CRDT inside sqlite that can understand the semantics of sqlite's data, like cr-sqlite is doing: https://github.com/vlcn-io/cr-sqlite
    comment by josephg · 2023-01-09 · in CDC File Transfer
  30. …system. It’s for a different use-case — local first software including peer to peer sync use-case. https://github.com/vlcn-io/cr-sqlite 51 days ago: https://news.ycombinator.com/item?id=33606311
    comment by jitl · 2023-01-05 · in LiteSync – Easy synchronization of SQLite databases
  31. cr-sqlite is a similar project on SQLite, but it's a standalone extension without a web framework. https://github.com/vlcn-io/cr-sqlite/
    comment by AlexErrant · 2023-01-03 · in Ask HN: What are you working on this year?
  32. https://github.com/vlcn-io/cr-sqlite/ > Tables are modeled as GSets... > Rows are currently modeled as LWW maps. I.e., each column in a row is a LWW Register. Multi value registers are also planned - though I'm not sure how that'll be…
    comment by AlexErrant · 2022-12-08 · in 5000x faster CRDTs: An adventure in optimization (2021)
  33. …layer is a big missing piece here. But some people are working on adding CRDTs to sqlite: https://github.com/vlcn-io/cr-sqlite It'd be really fun to see if this approach can be adapted to sqlite's b-tree. But it might not work as-is. The…
    comment by josephg · 2022-12-08 · in 5000x faster CRDTs: An adventure in optimization (2021)
  34. https://github.com/vlcn-io/cr-sqlite/tree/ca9a67f9050844458e... It's not very clearly stated, but the links show it has "Last Write Wins" semantics for conflicting changes https://bartoszsypytkowski.com/crdt-map/#crdtmapwithlastwrit...…
    comment by anentropic · 2022-11-15 · in Crsql – Multi-writer and CRDT support for SQLite