← Back to lessons|architecture
Passkeys not supported in this browser
Event Sourcing over CRUD for Audit Trails
Adopted Event Sourcing over CRUD in PostgreSQL to preserve full audit trail.
lesson_learnedevent-sourcingaudit-trailcompliance
Created 7/24/2026, 1:57:11 AM
Content
Decision: Replace standard CRUD in PostgreSQL with Event Sourcing for financial transaction audit trails. Rationale: CRUD updates overwrite previous states, making it impossible to provide compliance with history of changes. Database triggers were considered but rejected because they lose business context. Immutable domain events stored in Kafka, with Postgres materialized view for fast reads.