[Feature]: Blockchain Event Listener Service

[SudiptaPaul-31]

🔍 Problem Statement

📖 Description

Develop a background worker service that listens to Stellar blockchain events and keeps the application state in sync. This service will update escrow statuses and milestone progress in the database based on real-time blockchain activity.

Expected Behavior

• Listen to Stellar Events:

  • Subscribe to relevant Stellar network events (e.g., contract execution, escrow updates).
  • Continuously monitor for changes without blocking main application flow.

• Update Escrow Status in DB:

  • Reflect escrow deposits, releases, and refunds in the database.
  • Ensure consistency between blockchain state and application state.

• Sync Milestone Updates:

  • Update milestone status when blockchain events confirm completion or payment release.
  • Trigger notifications for clients and freelancers when milestones change state.

🛠 Technical Notes

• Implement as a background worker (e.g., Node.js worker, queue consumer, or cron job).
• Use Stellar SDK or Soroban APIs for event subscription and parsing.
• Ensure idempotent updates to prevent duplicate records.
• Maintain secure error handling and logging.
• Optimize for scalability to handle multiple contracts and milestones concurrently.
• Ensure compatibility with existing Postgres schema (projects, milestones, contracts, disputes).

✅ Acceptance Criteria

• Worker successfully subscribes to Stellar events.
• Escrow status updates are reflected in the database in real time.
• Milestone progress is synced correctly with blockchain confirmations.
• Notifications are triggered for relevant updates.
• Service runs reliably in background without blocking API routes.
• npm run lint and npm run build succeed.
• No regression in authentication, wallet connection, or dashboard features.

📈 Expected Impact

High — Would significantly improve user experience

[drips-wave]

This issue has been added to the Stellar Wave Program and is worth 200 Points.

🧑‍💻 Interested in contributing? Apply to work on this issue on Drips Wave, earn points, and receive rewards.

Warning

Only applications submitted via the apply link above will be considered. Please do not apply by commenting on the issue or opening a PR directly.

🤠 Repo maintainers: You can manage this issue's Points and Complexity on your Maintainer Dashboard here. Please keep an eye on applications and respond quickly 💙

ℹ️ Learn more about Drips Wave

[Tola-byte]

@Tola-byte has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I would like to do this.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Tola-byte to this issue.

[mikevill20]

@mikevill20 has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hello maintainer, i would love to work on this issue, please assign. thanks

ℹ️ Repo Maintainers: To accept this application, review their application or assign @mikevill20 to this issue.

[Awointa]

@Awointa has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hi maintainer 👋 I’d like to work on this issue.

I’ll implement the background worker to listen to Stellar events, sync escrow and milestone updates with the database, ensure idempotent processing, and handle notifications. I’ll also make sure the service runs reliably in the background with proper logging and error handling.

Ready to get started — please assign it to me if available.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Awointa to this issue.

[walterthesmart]

@walterthesmart has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hi @SudiptaPaul-31, I would like to work on this issue.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @walterthesmart to this issue.

[drips-wave]

Congratulations, @mikevill20! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on February 26, 2026.

🧑‍💻 @mikevill20: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are issued when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊