Use litestream as event source (CDC)

[ejemba]

Hi,

I was wondering, if it could be possible using litestream as event source rather than sending replica to store.
Debezium kind of doing this but for postgres or mysql.

The idea is « Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers »

In fact, i would love having SQLite as event source origin to a generic queue for a very simple CQRS architecture.

Thank you

[benbjohnson]

Hi @ejemba, yes, it is possible to do CDC but it's not implemented in Litestream yet. The SQLite record format is relatively simple to parse and SQLite provide parent references via ptrmap pages to determine what table the record belongs to.

There's an open issue for CDC on the repo that you can follow: #129

[ejemba]

@benbjohnson thank you !
sorry I did not see the issue #129
I will follow this one with <3 !!