Reply
Highlighted
Member
Posts: 1
Registered: ‎01-09-2020

Best way to mark and store viewed posts of individual in a social media app using MySQL, PHP and JS?

Hey guys, I'm new to MySQL and backend coding in general.

What is the best, most efficient way?

Thought of creating a relation by creating a separate table linking the already existing accounts table with "account_data" and in "account_data" have an array for each user marking the post as viewed so that he does not see it again and updating that. But if there are many posts there is a limit on how long an array can be, right?

Currently I have set an auto-increment for the post id's and accounts set up and working. Thanks in advance