go-outbox-pattern

What problem does it solve?

This Skill addresses the challenge of ensuring event delivery consistency between a database write and a message queue publish, preventing data loss even during system crashes.

Core Features & Use Cases

• Transactional Writes: Ensures database writes to both the domain table and the outbox table occur within a single atomic transaction.
• Reliable Publishing: Implements a polling worker that reliably publishes events from the outbox table to Kafka.
• Idempotency: Includes mechanisms for consumer idempotency to handle duplicate event deliveries.
• Use Case: When a new user is created in a Go microservice, this pattern guarantees that the user creation event is published to Kafka if and only if the user record is successfully saved to the database.

Quick Start

Scaffold the transactional outbox pattern for a Go microservice, including database migrations, transactional writes, a polling worker, and a Kafka publisher.