{
"type": "SET",
"op_list": [
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/explorations/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1/lessons|architecture/-P-4BfhoauHlI64K8ON4",
"value": {
"topic_path": "lessons/architecture",
"title": "Event Sourcing over CRUD for Audit Trails",
"content": "The team decided to use Event Sourcing instead of standard CRUD in PostgreSQL for financial transaction audit trails. The issue with CRUD is that updates overwrite previous states, making it impossible to provide compliance with the history of changes (e.g., who changed the status from pending to approved). Database triggers were considered but rejected because they lose business context -- triggers see row changes but not the 'why' or user intent behind them. Event Sourcing stores immutable domain events (TransactionCreated, TransactionApproved, StatusUpdated) using Kafka for the event log, with a materialized view in Postgres for fast reads. This follows Martin Fowler's Event Sourcing Pattern article. Implementation: event producers in src/services/transactionService.ts, consumer/store logic in src/events/eventStore.ts.",
"summary": "Team decided on Event Sourcing over CRUD for financial transaction audit trails to meet compliance requirements, using Kafka for immutable event storage and Postgres materialized views for reads.",
"depth": 2,
"tags": "lesson_learned,event-sourcing,audit,compliance,postgres,kafka",
"price": null,
"gateway_url": null,
"content_hash": null,
"created_at": 1786793606004,
"updated_at": 1786793606004
}
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/index/by_topic/lessons|architecture/explorers/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"value": 186
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/graph/nodes/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1_lessons|architecture_-P-4BfhoauHlI64K8ON4",
"value": {
"address": "0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"topic_path": "lessons/architecture",
"entry_id": "-P-4BfhoauHlI64K8ON4",
"title": "Event Sourcing over CRUD for Audit Trails",
"depth": 2,
"created_at": 1786793606004
}
}
]
}