`ProgressService` recalculates and writes on every read

[mercy60]

Internal ID: #51

Imported from ISSUES.md via scripts/import-issues.mjs.

Problem Statement. backend/src/progress/progress.service.ts:

const percentComplete = (progress.completedPuzzles / progress.totalPuzzles) * 100;
progress.percentComplete = parseFloat(percentComplete.toFixed(2));
await this.progressRepo.save(progress);

Every read is also a write. Under load this multiplies DB traffic.

Expected Outcome.

• Percent is computed inline at read time (it's a derived field); remove percentComplete from persistence or compute via DB computed column.
• Or: maintain lastUpdated from totals change.

Acceptance Criteria.

• No write on read. Load test confirms.

Implementation Notes.

• Add @AfterLoad hook (progress.percentComplete = compute(...)).

Files / modules affected.

• backend/src/progress/progress.service.ts
• backend/src/progress/progress.entity.ts

Dependencies. None.

Difficulty / Effort. Easy / S (≈ 2 hours).

Labels. area:backend, performance, tech-debt

[abdulquadri123]

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

Hi Drip Team,
I'm delighted to be able to contribute to the issues in this wave and I will be delighted if this issue is assigned to me as a pro blockchain developer.
Thanks.

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

[attyolu]

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

Hello Maintainer. I would resolve this issue quickly. Please assign to me. Thank you

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

[monique-7arch]

@monique-7arch has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi there, I'd like to contribute to this.

I'm a full-stack developer with solid experience in modern JavaScript/TypeScript, REST APIs, and frontend frameworks like React. I enjoy working in open source and following existing project conventions.

I've looked into this issue closely and I'm confident in my ability to deliver a high-quality implementation here.

I'd appreciate being assigned to this issue and look forward to contributing.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @monique-7arch to this issue.

[drips-wave]

Congratulations, @monique-7arch! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

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

😎 @monique-7arch: 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.