Comparing the outbox pattern to alternatives like “listen-to-yourself” and 2-phase commit (2PC) transactions. What’s the best choice for data exchange flows between microservices?
The outbox pattern asks for what replication already provides — durable, ordered, resumable delivery. Postgres' pg_logical_emit_message lets your application piggyback on that, walked line by line through factlib + OwlPost.
The dual-write problem is present in any distributed system and is difficult to solve. We discuss where the problem arises and several approaches.
What actually happens when you start a Temporal workflow? We trace every SQL statement, count the event-history nodes, and then watch Absurd — a 5-table, single-SQL-file system — do the same job with one-fifth the queries and twenty-times the throughput.
This post originally appeared on the Decodable blog. All rights reserved. Over the last few years, the outbox pattern has become a common solution for implementing data exchange flows between …