IndividualStatisticsPresenter and user profile page rely on Revisions table

[ragesoss]

We are deprecating the Revisions table and have removed old revisions from the production databases. However, the user profile pages — particularly, the feature for showing 'contributions as a student' — still relies on data from this table.

We need to either update the way this works so that it does not rely on the Revisions table (which may mean displaying a more limited amount of stats) or just remove this feature entirely.

[osujipius]

I will work on this

[EmmanuelEmp]

@ragesoss I would also like to work on this. After looking through the IndividualStatisticsPresenter query logic responsible for extracting the data, I was thinking if it was okay for the statistics section of the dashboard to now focus on articles created by a student rather than those edited (i.e. revisions).

[omChauhanDev]

@ragesoss Sir, for removing revisions table dependency there were two approaches:

Strategy 1: Create New Contribution Tracking

• Create a focused StudentContribution model for essential metrics only.
• Track:
  • Characters
  • References
  • Article creation
  • Views
• Update statistics presenter to use the new model.
• Migrate critical historical data.

Strategy 2: Remove Feature

• Remove the StudentStats component.
• Remove IndividualStatisticsPresenter.
• Clean up UI/routes.

Conclusion

• Strategy 1 if contribution tracking matters for program assessment.
• Strategy 2 if the feature isn't critical for core functionality.

Kindly share your thoughts on which approach would be best to follow.

[ragesoss]

@omChauhanDev I think Strategy 2 is the best option at this point. We can look into an efficient way to replace it with similar functionality later on, perhaps, but it's not critical.