Implement a Transactional Outbox for Guaranteed Event Delivery

[meshackyaro]

Description

This issue aims to address the implementation of Implement a Transactional Outbox for Guaranteed Event Delivery.

The core objective is to: Persist domain events in the same DB transaction as state changes and relay them to the WebSocket gateway and queue with at-least-once delivery and dedup keys.

By completing this feature, we will ensure that the TrustFlow protocol maintains its high standards for security, usability, and decentralized logic. This issue requires careful attention to the Backend architecture and adherence to the existing project conventions.

When picking up this issue, please ensure you document any new dependencies or architectural decisions made during development.

Component

Backend

Difficulty

🔴 Hard

Tasks

• Review Node.js API architecture in backend/
• Implement logic for: Implement a Transactional Outbox for Guaranteed Event Delivery
• Write unit tests for the new endpoints using Supertest
• Update Swagger terminology / OpenAPI specs
• Verify PostgreSQL queries are optimized
• Run npm run lint

Acceptance Criteria

• Feature accurately implements the objective: Persist domain events in the same DB transaction as state changes and relay them to the WebSocket gateway and queue with at-least-once delivery and dedup keys.
• Any PR that introduces TypeScript errors is automatically blocked
• CI pipeline runs in under 3 minutes per PR
• Code is properly reviewed and approved by codeowners

Estimated Time

3-5 days

[nurudeenheroic]

Hello! I'm confident I can deliver a clean implementation that aligns with the project's expectations. I'd love to work on this issue.