I'm trying to create a script so that members on my site can vote for certain posts. I want to be able to retrieve all types of information like who voted for each post and what posts each person voted for and eventually get even more detailed statistics. My idea is that for every vote that is made, I store the id of the post in a column called post_id and the id of the member voting in the second column called voter_id. But the problem with that is there would be a new row for each and every vote, which would make the database HUGE after a while. Would this be a good way to manage the votes or is there a better way to do this?
If you want to know who voted for every post and what posts each person voted for, this is the only way.