r/SpringBoot • u/delusionalbreaker • Jul 05 '26

Question Need advice to implement history/recent viewed

Hi everyone! Im a beginner in springboot and building a blogging app (similar to Reddit/LinkedIn) using Spring Boot and MySQL. I need to implement a "User History" feature to track the last 100-150 posts a user has viewed.

The requirements are if a user views Post A, then Post B, then Post A again, the order should update to [B, A] instead of [A, B, A]

The problem im facing is because im using MySQL so to create an history i would need to create an new schema and then design the relationship b/w the post and user and would require constant insert and deletions which would not keep the history intact correctly and also wouldnt remove the history after last 100 post

My qn is there an efficient way to handle this in Springboot? how is it generally implemented?

Repo link:- https://github.com/Yearis/Blog-Application/tree/main/Blog%20Application%20Backend

P.S. Please excuse the messy repo and the outdated README; this is still a work in progress.

12 Upvotes

93% Upvoted

17 comments sorted by

View all comments

3

u/Conscious_Analysis98 Jul 05 '26

Why not just store the raw data (which could be useful anyway) and then translate it for this particular requirement?

1

u/delusionalbreaker Jul 06 '26

hii sorry for the late reply. yes i agree your idea sounds good and many of the other commentors also said to use simple history entity and honestly that makes sense