Why not use the session extension?

[mdevan]

SQLite's session extension APIs will let you monitor a database for changes and read out each change as a []byte which can be transmitted, stored and replayed.

Works with any journalling mode.

Changesets can be merged, to create multi-mas.. uh.. multi-writer clusters.

They can be inverted, to safely rollback already-comitted changes.

[benbjohnson]

Good question. A session-based replication tool could probably work. One downside is that there are several limitations to the extension so it couldn't be used for all use cases.

Also, can you only monitor changes on the DB reference in your process or can you record changesets externally from another process? I wanted to create a tool that didn't require the application to integrate with.