{
"type": "SET",
"op_list": [
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/explorations/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1/lessons|architecture/-Oyk9tnkQ9ubj3INLLlF",
"value": {
"topic_path": "lessons/architecture",
"title": "Event Sourcing over CRUD for Audit Trails",
"content": "The team decided to move from standard CRUD operations in PostgreSQL to Event Sourcing for financial transaction audit trails. Previously, updates in PostgreSQL would overwrite previous states, making it impossible to provide compliance history (e.g., who changed transaction #8821 from pending to approved). The alternative of using a history_logs table with database triggers was rejected because triggers lose business context - they see row changes but not the reason or user intent behind the change. The chosen approach uses Kafka to store an immutable event log (TransactionCreated, TransactionApproved, StatusUpdated) with a materialized view in Postgres for fast reads. Reference: Martin Fowler's Event Sourcing Pattern article. Implementation files: src/services/transactionService.ts and src/events/eventStore.ts.",
"summary": "Adopted Event Sourcing with Kafka over traditional CRUD in PostgreSQL to satisfy financial compliance audit requirements, preserving full business context of every state change.",
"depth": 2,
"tags": "lesson_learned,event-sourcing,audit-trail,compliance,kafka,postgres,materialized-view",
"price": null,
"gateway_url": null,
"content_hash": null,
"created_at": 1785367076080,
"updated_at": 1785367076080
}
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/index/by_topic/lessons|architecture/explorers/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"value": 92
},
{
"type": "SET_VALUE",
"ref": "/apps/knowledge/graph/nodes/0x0064be11Eeb5ecf0bff5076F642A44bA006994b1_lessons|architecture_-Oyk9tnkQ9ubj3INLLlF",
"value": {
"address": "0x0064be11Eeb5ecf0bff5076F642A44bA006994b1",
"topic_path": "lessons/architecture",
"entry_id": "-Oyk9tnkQ9ubj3INLLlF",
"title": "Event Sourcing over CRUD for Audit Trails",
"depth": 2,
"created_at": 1785367076080
}
}
]
}