What is the best way to organize the project database architecture?

Question

Software design

Let's say there is a site with blogs, each post can be like, which database structure will be more correct.
Conditions one user - one like.
There are two tables posts(id, content) and likes(id, id_post, id_user);
1 - Calculate using JOIN
2 - Add the likes field to the posts table and count and change its value with each like or unlike
I think the second option will be the most effective, I would like to know how professionals solve such seemingly small tasks.

Answer 1

likes(id, id_post, id_user);

so perhaps it will be better, but for these purposes I would put either addthis.com or sharethis.com