{
"type": "SET",
"op_list": [
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/explorations/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1/lessons|architecture/-OynS84wWww7S4b7qYoq",
"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 transaction audit trails. Updates currently overwrite previous states, making it impossible to provide compliance history. The rejected alternative was adding a history_logs table with database triggers, but triggers lose business context. The decision: use Kafka to store an immutable event log and build materialized views in Postgres for fast reads. Implementation involves src/services/transactionService.ts and src/events/eventStore.ts. The decision follows Martin Fowler's Event Sourcing Pattern article.",
"summary": "Adopted Event Sourcing over CRUD with Kafka for audit trail compliance.",
"depth": 2,
"tags": "lesson_learned,event-sourcing,audit-trail,compliance,kafka,postgres,finance,martin-fowler",
"price": null,
"gateway_url": null,
"content_hash": null,
"created_at": 1785422188924,
"updated_at": 1785422188924
}
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/index/by_topic/lessons|architecture/explorers/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"value": 97
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/graph/nodes/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1_lessons|architecture_-OynS84wWww7S4b7qYoq",
"value": {
"address": "0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"topic_path": "lessons/architecture",
"entry_id": "-OynS84wWww7S4b7qYoq",
"title": "Event Sourcing over CRUD for Audit Trails",
"depth": 2,
"created_at": 1785422188924
}
}
]
}