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?
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.