Craft VS verneuil

Here’s the original code: https://github.com/fogleman/Craft/blob/master/src/world.c I don’t really have an “after” because I edited it a lot and didn’t backup the original, but try it yourself and you should get similar results. I also told it to make the variable names better.

When this subject comes up, I always like to link to one of the many Minecraft clones written in C. https://github.com/fogleman/Craft

Not java but https://github.com/fogleman/Craft will give you an idea of what has to be done.

It'd be process wide. If you want an example can check out the example using a vfs here. There's an explicit passing of vfs there and an implicit usage of it. https://github.com/backtrace-labs/verneuil/blob/main/examples/rusqlite_integration.rs

It doesn't even have to be WAL-based system. Backtrace Labs has a SQLite virtual file system (VFS) called Verneuil that works similarly but works with the rollback journal instead of the WAL.

https://github.com/backtrace-labs/verneuil/ is one way to address the diffing / read replica part of the problem. I believe it's compatible with gossipping: most of the data is in small content-addressed chunks, with small manifests that tell clients what chunks to fetch and how to reassemble them to recreate a sqlite database. There's already client-side caching to persistent storage, and chunks can be fetched on demand.

Sharing replication data P2P, while retaining the simplicity of a single authoritative writer per database, is explicitly part of the project's long-term goals!