Integrate Stellar RPC for live contract queries

[ogazboiz]

Join our community: https://t.me/+DOylgFv1jyJlNzM0

Description

All stream data is served from the indexed database. If the indexer falls behind or crashes, clients see stale data with no indication. Critical reads (claimable amount, stream status) should be backed by a live RPC fallback.

What Needs to Happen

• Create backend/src/services/sorobanService.ts wrapping Stellar SDK contract calls
• getStreamFromChain(streamId) — invoke get_stream() as a read-only simulation
• getClaimableFromChain(streamId) — invoke get_claimable_amount()
• Use on-chain data as fallback when DB updatedAt is older than 30 seconds
• Add SOROBAN_RPC_URL and CONTRACT_ID to .env.example

Files

• backend/src/services/sorobanService.ts (create)

Acceptance Criteria

• Live contract queries work for both stream and claimable amount
• Fallback activates when DB is stale
• RPC errors are caught and logged without crashing the API

[2411015047-afk]

Hi! I can implement the Stellar RPC integration with live contract query fallback.

I have hands-on experience with:

• Stellar SDK contract invocation (Soroban RPC)
• Read-only simulation for get_stream() calls
• Service layer architecture for blockchain data

This is a solid backend improvement. Let me know if you'd like to hire this out — I can provide a quote based on the spec you've outlined.

[TheBigWealth89]

@TheBigWealth89 has applied to work on this issue as part of the Stellar Wave Program's 4th wave.

Hi Maintainer, please I would like to work on this issue.

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

[shakurJJ]

@shakurJJ has applied to work on this issue as part of the Stellar Wave Program's 4th wave.

I would like to work on this issue

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

[drips-wave]

Congratulations, @shakurJJ! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on April 29, 2026.

🧑‍💻 @shakurJJ: 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 awarded 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 🌊

[drips-wave]

This issue has been completed by @shakurJJ as part of the Stellar Wave Program's 4th Wave 🥳

😎 @shakurJJ: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.