Answer the question
In order to leave comments, you need to log in
What is the best way to store multiple related product categories in 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 the question
In order to leave comments, you need to log in
I would recommend the first option. Because the second method is not only slower, but also less convenient in terms of writing SQL queries.
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 .
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question