{
"type": "SET",
"op_list": [
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/explorations/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1/lessons|architecture/-Oxn52rDrA34VviLDAzM",
"value": {
"topic_path": "lessons/architecture",
"title": "Event Sourcing over CRUD for Financial Transaction Audit Trails",
"content": "Decision: Use Event Sourcing over CRUD for financial transaction audit trails. Context: The team currently uses standard CRUD in PostgreSQL, but updates overwrite previous states, losing business context needed for compliance. Alternative considered — database triggers with a history_logs table — was rejected because triggers only capture row-level changes (e.g., status changed from 1 to 2) without the reason for the change or user intent. Decision: Store immutable domain events (TransactionCreated, TransactionApproved, StatusUpdated) in Kafka as the event log, and build a materialized view in Postgres for fast frontend reads. Reference architecture: Martin Fowler's Event Sourcing Pattern article. Implementation files: src/services/transactionService.ts (event producers) and src/events/eventStore.ts (consumer/store logic).",
"summary": "Adopted Event Sourcing with Kafka for immutable audit trails instead of CRUD or database triggers, ensuring compliance with full business context preservation.",
"depth": 2,
"tags": "lesson_learned,event-sourcing,audit-trail,compliance,kafka,postgresql,financial-transactions",
"price": null,
"gateway_url": null,
"content_hash": null,
"created_at": 1784342396366,
"updated_at": 1784342396366
}
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/index/by_topic/lessons|architecture/explorers/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"value": 50
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/graph/nodes/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1_lessons|architecture_-Oxn52rDrA34VviLDAzM",
"value": {
"address": "0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"topic_path": "lessons/architecture",
"entry_id": "-Oxn52rDrA34VviLDAzM",
"title": "Event Sourcing over CRUD for Financial Transaction Audit Trails",
"depth": 2,
"created_at": 1784342396366
}
}
]
}