How to implement a transactional outbox pattern or different pattern with scylladb to write the event to scylladb first and then process it in micro batches to mitigate the dual write problem and garuntee event publishing
AFAIU the Transactional Outbox pattern in microservices, one can use ScyllaDB CDC to track updates to a table (e.g., service 2 in Transactional outbox).
Note that ScyllaDB does not support multi-table transactions, so there is no way to insert data to two tables (Order table and Outbox table) in one transaction.