Peer-to-peer replication of a sqlite database

Question

I am looking for a way to replicate a small and simple relational database (like SQLite) across peers. This should work in an environment with unstable network connections, hence the need for each peer to have a full copy of the database. This should allow a peer to continue working off-line in the event of network failure.

To keep things simple, replication should only have to support the replication of addition of data, i.e. only INSERTs, not DELETEs or UPDATEs.

Does anyone know of a good - and ideally cross-platform - technology or method of creating such a system? I am currently looking at JXTA and JXSE, but I am put off by its complexity and apparant lack of life in its community after the takeover of Sun by Oracle.

Thanks! Frans

Answer 1

rqlite uses the raft consensus algorithm, so it should be fairly resilient to unstable network connection.

Also, it seems to be possible to configure rqlite to accept reads even in the case of a network failure.

A similar project, dqlite, exists as a library, available in various languages, but it seems less explicit about the event of a network failure.