Implement Blockchain Event Indexing Module

[akargi]

Description

Create a robust blockchain event indexing module that monitors Stellar blockchain for relevant events, indexes them efficiently, and makes them queryable for business logic operations.

Direction

This module should:

• Monitor blockchain transactions for trade-related events
• Index events with transaction hash, ledger number, and timestamp
• Support filtering and querying indexed events
• Handle blockchain reorganizations gracefully
• Maintain indexing state for recovery after failures
• Provide real-time event streaming capabilities

Acceptance Criteria

• All blockchain events are indexed within 5 seconds of confirmation
• Indexing state is persisted and survives application restarts
• Query performance for indexed events is <100ms for 1M+ events
• Blockchain reorg handling prevents data inconsistency
• Real-time event streaming delivers events within 2 seconds
• Indexing module recovers from failures without data loss
• Event filtering supports multiple criteria (address, amount, type)
• Comprehensive integration tests validate indexing accuracy

[midenotch]

I'd like to work on this issue.

This is an interesting systems problem that combines blockchain event processing, reliability, and performance. My approach would be to build a resilient indexing module that continuously monitors the Stellar blockchain for relevant trade events, persists indexing state for seamless recovery after failures, and stores indexed events with transaction hash, ledger number, timestamp, and other searchable metadata.

To meet the performance and reliability requirements, I'll design the indexer to support efficient querying through appropriate database indexes, implement checkpointing to avoid data loss on restarts, and include reorganization handling to ensure indexed data remains consistent if the blockchain changes. I'll also expose a real-time event stream for downstream consumers while ensuring events are delivered with minimal latency.

Finally, I'll write comprehensive integration tests covering indexing accuracy, recovery from failures, reorganization scenarios, filtering capabilities, and query performance to ensure the implementation satisfies the project's acceptance criteria.

I have experience building TypeScript backend services, integrating external APIs, and developing reliable event-driven systems with a strong focus on correctness, scalability, and maintainability.

[Dijjy7]

Hello maintainer am a fullstack developer i have carefully read this issue requirement and am confident in my skill to achieve please assign me

[grantfox-oss]

🦊 GrantFox — @Dijjy7 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 #10)
2. Your PR will be reviewed by the Chulilee maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Official Campaign | FWC26 campaign!

@Dijjy7's PR #18 was approved and merged by @akargi.

🏆 @Dijjy7: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (118 total points). Track your full progress on GrantFox.

👏 Great work, @Dijjy7! Keep contributing to Chulilee.