What is the best way to organize the storage of goods in a table?

Question

PHP

What is the best way to store products in the database, given the fact that each group of products can have its own unique characteristics. For example, a TV has contrast ratio, but a microwave does not. And how to be in such a situation, what is the best way to organize the database?

Answer 1

eav

Answer 2

Related question: Is it possible to do without Entity-Attribute-Value?
They discuss including EAV.
Article to help: habrahabr.ru/post/45935

Answer 3

Use postgres
Use hstore

Answer 4

Both a group and one product in a group can have their own characteristics. There are too many nuances.
Try to take some cms and see how the storage of goods is arranged there. For example, diafan has a well-thought-out base.