On-Chain Event Ingestion Pipeline with Transactional Outbox & Replay

[meshackyaro]

Description

This issue aims to address the implementation of On-Chain Event Ingestion Pipeline with Transactional Outbox & Replay.

The core objective is to: Build a resilient pipeline that ingests Soroban contract events into PostgreSQL using the transactional outbox pattern, with ordered processing, dead-letter handling, and deterministic replay.

By completing this feature, we will ensure that the GuildWorkman 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 (Spring Boot / Java 17)

Difficulty

⚫ Very Hard

Tasks

• Review the existing Spring Boot structure under backend-api/src/main/java
• Implement the service and REST endpoints for: On-Chain Event Ingestion Pipeline with Transactional Outbox & Replay
• Add or adjust JPA entities, repositories, and schema migrations as needed
• Write unit and integration tests (Spring Boot Test; MockWebServer for external RPC calls)
• Add caching for Maven dependencies in CI
• Run ./mvnw verify and ./mvnw test to validate build and coverage

Acceptance Criteria

• Feature accurately implements the objective: Build a resilient pipeline that ingests Soroban contract events into PostgreSQL using the transactional outbox pattern, with ordered processing, dead-letter handling, and deterministic replay.
• Any PR that introduces failing tests or compilation errors is automatically blocked
• Endpoints/services are covered by tests including failure and concurrency paths
• Public API is documented (OpenAPI) and errors follow a consistent response contract
• Code is properly reviewed and approved by codeowners

Estimated Time

3-5 days

[Silver36-ship-it]

I would love to work on this professionally, please assign it to me

[ebubeb683-ship-it]

Hello boss, Please assign this issue to me. i checked it out and im confident i will solve it
my eta is 4 hours

[benfoster-dev]

HI maintainer

please can i get assigned to this issue please am a smart contract engineer

[realvic22]

Hello maintainer, I can handle this issue. Please assign

[grantfox-oss]

🦊 GrantFox — @realvic22 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 #22)
2. Your PR will be reviewed by the workman-labs maintainers

Good luck! Track your progress on GrantFox.