Build an Idempotent, Reorg-Safe Soroban Event Ingestion Pipeline

[meshackyaro]

Description

This issue aims to address the implementation of Build an Idempotent, Reorg-Safe Soroban Event Ingestion Pipeline.

The core objective is to: Ingest escrow and dispute contract events exactly-once with ledger-cursor checkpointing, so chain reorgs and RPC retries never double-apply or drop events.

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: Build an Idempotent, Reorg-Safe Soroban Event Ingestion Pipeline
• 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: Ingest escrow and dispute contract events exactly-once with ledger-cursor checkpointing, so chain reorgs and RPC retries never double-apply or drop events.
• 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 understand what's needed and can deliver a solution that meets the project's standards. I'd love the opportunity to work on this issue. @maintainer

[OluRemiFour]

Hi Maintainer,
Interested in working on this issue. I'll implement the requested changes and ensure everything is properly tested before submission.

[Wilfred007]

Hi Maintainer
Ive look through this task requirements and I can categorically say it's a task I can handle without wasting time. Kindly assign

[grantfox-oss]

🦊 GrantFox — @Wilfred007 has been assigned to this issue as part of the Official Campaign | FWC26 campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #163)
2. Your PR will be reviewed by the trustflow-protocol maintainers

Good luck! Track your progress on GrantFox.