so we have already tried kafka. Kafka can get complicated if the kafka-connectors are not configured properly. I'm trying to do the write-to-db and write-to-spicdDB method now, but what is about outbox pattern?

Outbox pattern is writing records to both the normal tables and an "updates" table

hmm, this also sounds interesting