Yii And Eav

I’m looking for a solution to manage different types of products. Entity-Attribute-Value is an alternative but I heard lots of negative points about it. Is there any experience or suggestion about EAV in Yii?

If you want to try a document store instead of EAV, there are a few extensions for MongoDB: directmongosuite, mongorecord, yiimongodbsuite.

If you would need to relate the products, why not use the PRODUCT, TYPE, CATEGORY, CLASSIFICATION model pattern? I would personally stay away from the eav pattern due to maintaining issue.

Document based NoSQL could be another option

I have no experience on MongoDB, for now I prefer to stay with Mysql.

My actual purpose to use those fields for filtering and navigation. So mostly those fields will be used for searching.