The linked projects (<a href="https://vlcn.io" rel="nofollow">https://vlcn.io</a> and <a href="https://github.com/vlcn-io/cr-sqlite">https://github.com/vlcn-io/cr-sqlite</a>) 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.
Very cool. CRDTs seem to be in the air. I was searching for something unrelated and bumped into <a href="https://mycelial.com/" rel="nofollow">https://mycelial.com/</a> which is also doing CRDTs with sqlite. Very helpful intro to CRDTs video on their youtube channel.
Interesting that is uses sqlite as a file format as an example for rich documents. Probably would work reasonably well, but hadn't thought to do that until now. Have tables for pages and items on the page? Would that make document search more robust?<p>Wonder if/how it would combine with the distributed litestream stuff recently touted on fly.io? I love postgres but have to admit these features are tempting.
wonder if there is an estimate to quantify what “eventual” means as a function of the variables of a peer ecosystem … e.g., the number of nodes, the frequency of updates, etc. …