Top all-time · #9092
vlcn.io
Company blog · vlcn.io/blogprogrammingdata
vlcn.io is the company blog at vlcn.io, writing about programming and data. Since 2023, 9 different Hacker News readers have linked it 15 times. The last post was in 2023, but the archive is still widely read.
Too few sampled comments (12) to say how often HN recommends it.?
Why HN links it
HN readers link vlcn.io as the home of cr-sqlite, a SQLite extension for CRDT-based syncing between databases. Commenters cite its docs on local-first apps, syncing across browser tabs and SQLite persistence options.
Summarised by Claude from a sample of 12 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Make collaborative, multiplayer or local-first applications
Most-linked posts?
- /4 people · 4 mentions · first linked 2023-02-11
- /2 people · 3 mentions · first linked 2023-05-18
- /docs/cr-sqlite/intro2 people · 2 mentions · first linked 2025-03-03
What Hacker News says?
in case anyone finds this useful, here's the slowly growing collection of links to similar tools: https://tinybase.org/ https://www.evolu.dev/ https://replicache.dev/ https://fireproof.storage/ https://vlcn.io/ https://www.instantdb.com/ https://loro.dev/ https://electric-sql.com/ https://docs.y-sweet.dev/ https://syncedstore.org/docs/ https://collabs.readthedocs.io/en/latest/ https://remotestorage.io/ https://rxdb.…
Comment linking /
on “Stop syncing everything”Submitted A Framework for Convergence – What if I told you anyone can create a new CRDT? as a story · 1 points
HN discussionthere's also a CRDT version of this, which allows two databases to be sync'ed to each other in real time (aka, updates to one will eventually make it to the other, and both database would eventually contain the same data). It's https://vlcn.io/docs/cr-sqlite/intro , and i find it amazing that this is doable in sqlite. It is perfect for small scale collaboration imho, but it also works to sync across local client and…
Comment linking /docs/cr-sqlite/intro
on “SQLite-on-the-server is misunderstood: Better at hyper-scale than micro-scale”Submitted A Framework for Convergent State as a story · 1 points
HN discussionHave your tried CR-SQLite ? https://vlcn.io/docs/cr-sqlite/intro It implements CRDT as SQLite extension.
Comment linking /docs/cr-sqlite/intro
on “SQLite-on-the-server is misunderstood: Better at hyper-scale than micro-scale”Submitted A Gentle Introduction to CRDTs as a story · 1 points
HN discussionIf you fetch from a repo with a slightly different history for a named branch than what you have locally, git fetch will fail. Thus git fetch operations are not part of a CRDT. Similarly, the order in which you synchronize (fetch or merge) from remote sources is order dependent and does not eventually converge to the same result (e.g. the commit hashes will diverge for a simple reason that the current time is part o…
Comment linking /blog/intro-to-crdts
on “Faster CRDTs (2021)”I am fully on the offline-first bandwagon after starting to use cr-sqlite ( https://vlcn.io ), which works similar to ElectricSQL. I thought the bundle size of wasm-sqlite would be prohibitive, but it's surprisingly quick to download and boot. Reducing network reliance solves so many problems and corner-cases in my web app. Having access to local data makes everything very snappy too - the user experience is much be…
Comment linking /
on “Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps”I wonder how this compares to https://vlcn.io ?
Comment linking /
on “Mycelite: SQLite extension to synchronize changes across SQLite instances”Not quite the answer to your question, but there are quite a few people looking at doing eventually consistent database syncing with CRDTs. Two interesting ones are: https://electric-sql.com/ - SQLite and Postgres syncing https://vlcn.io/ - SQLite syncing I've been experimenting with Yjs and merging documents in database via SQL, for both SQLite and Postgres. And allowing you to query the contents of those documents…
Comment linking /
on “CRDT-richtext: Rust implementation of Peritext and Fugue”What's wrong with many tabs? The DB handles getting hit by many tabs correctly -- it's just as if many processes were hitting the db in a non-browser environment. Example of syncing your app across tabs with SQLite here: https://vlcn.io/docs/guide-solving-tabs
Comment linking /docs/guide-solving-tabs
on “SQLite WASM in the Browser Backed by the Origin Private File System”If it helps, I detail some of the pros/cons of using the official SQLite build vs unofficial builds (wa-sqlite, which is similar to absured-sql) here: https://vlcn.io/docs/guide-persistence#persistence-options
Comment linking /docs/guide-persistence
on “SQLite WASM in the Browser Backed by the Origin Private File System”For a tenanted SAAS app SQLite at the edge is a really compelling architecture. You have a single DB per customer/company/group with all their users woking against that. It can operate at the edge, closest to where the majority of the customers users are. SQLite could scale to even quite large customers with this. Another really compelling architecture is a DB per user, with partial/selective sync between the nodes.…
Comment linking /
on “Why SQLite is so great for the edge”Anything CRDT (conflict free lated datatypes: https://en.wikipedia.org/wiki/Conflict-free_replicated_data_... ) related is fun to read up on and play with. Papers (page maintained by central academic in the world of CRDTs): https://crdt.tech Group doing research into how they can be used to build interesting collaborative (and async) applications: https://www.inkandswitch.com A few of the major open source implement…
Comment linking /
on “Ask HN: What is new in Algorithms / Data Structures these days?”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 WASM build of SQLite.
Comment linking /
on “A Gentle Introduction to CRDTs”
