subscribing to row-level updates

[petergaultney]

Given the new architecture described here, are we close to a point where Litestream could serve as a method of 'subscribing' to writes into a given database originating from multiple processes? This paradigm is quite useful for a lot of architectures as you can probably imagine.

I don't know enough about Litestream to guess whether this could be done using an inotify-style watcher of the files that Litestream outputs, but that's the approach I am vaguely imagining.

[benbjohnson]

Litestream does physical replication which means that it works at the page level rather than the row level. There is an issue for CDC (Change Data Capture) but it's a pretty tricky thing to implement well. It's not currently on the roadmap but it could happen in the future.