enhancement: add project stats snapshot event for indexer catch-up

[Naomi-Gift]

Indexers that restart or fall behind must replay all review events to reconstruct project statistics. A publish_project_stats_snapshot_event that emits current rating_sum, review_count, and average_rating on a configurable cadence (e.g., every N reviews) would allow indexers to bootstrap from a known-good checkpoint.

[Duyicoda]

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

Hi Maintainer, I’ve reviewed the issue and understand the need for periodic project statistics snapshots to help indexers recover efficiently. I can implement the snapshot event with configurable cadence and ensure the current rating metrics are emitted correctly. Kindly assign it to me.

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

[Herodos001]

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

I'm skilled in resolving this kind of issue. Please kindly assign

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

[esenyidaniel-hash]

@esenyidaniel-hash has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Please can I be assign this issue?

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

[drips-wave]

Congratulations, @esenyidaniel-hash! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @esenyidaniel-hash: 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 @esenyidaniel-hash as part of the Stellar Wave Program's 8th Wave 🥳

😎 @esenyidaniel-hash: 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.