Django ORM: database structure and query building for dynamic filter?

Question

MySQL

Greetings! It is necessary to display the number of products in each category and for each filtering parameter, do not show empty ones.
- Mysql database
- Filtering parameters are known (price, color, style, brand, pattern, composition, size)
- I would not like to use EAV, because no parameters are planned to be added. The
result is the following database structure

. Is this structure suitable for such a task? How to make a request in the orm to fetch this data?

Answer 1

RDBMS do not do well with such tasks. They are usually implemented by full-text search engines like Elasticsearch.