Implement Efficient Search/Filter Helper Functions

[Yunusabdul38]

Description

While most indexing happens off-chain, providing basic on-chain filtering (e.g., "get latest 10 pools in Category X") can be useful for light clients and basic contract interaction.

Tasks

• Maintain a secondary index of pool IDs by category symbol.
• Implement get_pools_by_category with pagination.
• Ensure indexes are updated correctly during pool creation.

Dependencies

• Issue Implement Market Categories as Symbols #306
• Issue Optimize Storage Usage Patterns (Ttl, Instance vs Persistent) #302

[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

[milah-247]

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

hi @Yunusabdul38,
I’d like to take on the Efficient Search Implementation task. I can design and implement an optimized search mechanism that improves data retrieval speed while keeping the logic clean and scalable.

My approach will focus on structuring storage and indexing efficiently to minimize computation and access costs. I’ll ensure the search handles edge cases properly, integrates seamlessly with existing modules, and maintains good performance even as data grows. I’ll also keep the implementation clear, well-documented, and aligned with best practices.

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

[jemilahshittu247-ctrl]

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

hi maintainer , can i please work on this issues

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