Develop 'Project Archive' cold-storage strategy

[gabito1451]

Context

Handling years of historical project data.

Problem

Keeping 10-year old completed projects in the main DB slows down everything.

Suggested Execution

• Create a task to move projects 'Completed' > 1 year ago to an 'Archive' table or S3 partition.
• Still accessible via 'Search' but removed from primary 'Explore' queries.

Acceptance Criteria

• Main database remains lean and fast.
• All historical data preserved and searchable.

References

• backend/src/jobs/archiver.job.ts

[AlienScroll78]

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

Dear maintainer i would love to work on this issue

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

[augustine0956]

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

I’d like to work on this issue. I’ll implement project archiving for completed projects older than 1 year, move them to archive storage while keeping them searchable, and ensure primary queries stay fast and clean.
ETA: 6 hours

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