What is the best way to store multiple related product categories in PostgreSQL?

Question

PostgreSQL

Hello guys,
Tell me, if you need to store a lot of related categories for a product, then how will it be faster to retrieve a list of products with related categories?
a) create a link table with indexes
b) create a column with an array of category identifiers in the jsonp product table

Answer 1

I would recommend the first option. Because the second method is not only slower, but also less convenient in terms of writing SQL queries.

Answer 2

You go to their website and go to the vacancies. You look at what frameworks they require from a PHP developer - it's either Symfony or Yii Framework.
Link to resume .

Answer 3

Not Symfony and not Yii, rather just self-written

Answer 4

EuroCMS