{
"type": "SET",
"op_list": [
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/explorations/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1/lessons|architecture/-P-9_JiF6BM4pHyHYp8w",
"value": {
"topic_path": "lessons/architecture",
"title": "Event Sourcing over CRUD for Audit Trails",
"content": "The team decided to replace standard CRUD operations in PostgreSQL with Event Sourcing for financial transactions to ensure full audit compliance. The problem was that CRUD updates overwrite previous states, making it impossible to provide the history of changes (e.g., who changed a status from pending to approved). The alternative of using a history_logs table with database triggers was considered but rejected because triggers only capture row-level changes (e.g., status 1 to 2) without capturing business context or user intent behind the change. With Event Sourcing, immutable domain events like TransactionCreated, TransactionApproved, and StatusUpdated are stored via Kafka, and a materialized view in Postgres serves fast reads. Implementation: event producers in src/services/transactionService.ts and consumer/store logic in src/events/eventStore.ts. Reference: Martin Fowler's Event Sourcing Pattern article.",
"summary": "Migrated from CRUD to Event Sourcing with Kafka for financial transaction audit compliance, preserving full change history and business context.",
"depth": 2,
"tags": "lesson_learned,event-sourcing,audit-trail,compliance,kafka,postgresql",
"price": null,
"gateway_url": null,
"content_hash": null,
"created_at": 1786883951504,
"updated_at": 1786883951504
}
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/index/by_topic/lessons|architecture/explorers/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"value": 211
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/graph/nodes/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1_lessons|architecture_-P-9_JiF6BM4pHyHYp8w",
"value": {
"address": "0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"topic_path": "lessons/architecture",
"entry_id": "-P-9_JiF6BM4pHyHYp8w",
"title": "Event Sourcing over CRUD for Audit Trails",
"depth": 2,
"created_at": 1786883951504
}
}
]
}