Questions tagged [EAV] (25)

0
answer

The program is not working, everything seems spelled correctly, but throws an error?

from kivy.app import App from kivy.uix.widget import Widget from kivy.properties import ( NumericProperty, ReferenceListProperty, ObjectProperty ) from kivy.vector import Vector from kivy.clock import Clock from random import randint class PongBall(Widget): # The speed of our ball along two axes velocity_x = Numeri...
shana.Crona33 asked April 16th 20 at 10:00
0
answer

The correct design of a database for EAV?

There is a working online store. Working on "samopisny" framework in PHP. The database is MySQL. At the moment, no more than 100 positions. In the coming year it is planned no more than 6,000 positions. Information about products (size,color, brand) are stored in one table. Products essentially similar. Soon will be added ...
winnifred_Goldn asked March 31st 20 at 20:48
0
answer

Whether to store values of attributes of individual columns in the EAV?

Faced with the task of storing entities with an arbitrary number of attributes. The number of attribute types are limited to: 7. If you use EAV, whether under each type to make a separate column ?+----+-----------+------------+----------+-----------+--------------+------------+ | id | entity_id | name | type | value_int | v...
Aurelie.Koch asked March 31st 20 at 14:58
0
answer

What is EAV model database, correct?

Good evening, began to study the essence of EAV database model and confused online, what is the model still correct or ... can't find the image but the fact that the ENTITY has a relationship to the ATTRIBUTE and he already has a relationship with the VALUE It seems logical that the correct option is the first, but don't kn...
vida10 asked March 11th 20 at 21:11
3
answers

What's wrong with EAV solution for an online store?

Faced with the problem when there are different types of goods (clothing and televisions have enough of the same parameters). I see 3 solutions to the problemSerialized LOB is the easiest, but there is no searchEAV is not a complicated implementation, there is no problem in updating the database. In General, like that. But ...
rodrick.Harvey81 asked October 10th 19 at 06:07
2
answers

EAV and select a data type

Actually just interested. At the moment in one of the projects needed versatile storage options for parts of the system. It can be both numbers and oversized texts. Because while they are stored in long text. question actually such, is it possible to store these settings in a more convenient way, because something tells me ...
Allene_Crona78 asked October 8th 19 at 04:55
3
answers

Yii, EAV, performance

Good night. Faced with this question. There's quite a heavy processing entities on the site based on Yii. Briefly describe the essence: there are products that have custom modifications (such as phones 8Gb and 16GB, but actually the parameters can be different + for one product can have multiple interrelated parameters and ...
hulda.Hya asked October 2nd 19 at 23:31
1
answer

How to use your storage model in Doctrine?

Need a stratum that will be able to save the attributes in an entity (for example, somehow marked), according to the model EAV. Out of the box Doctrine do not know how, a quick search on this topic, too gave nothing. Maybe searching wrong, or maybe called it something clever?
Harvey asked September 30th 19 at 10:44
2
answers

In Yii2 how to create a model with dynamic attributes (EAV)?

Hello! Faced with this problem, I can not understand how to properly implement the model in Yii 2 for this DB schema: In fact it is all familiar EAV - is the object, the object has properties which is set dynamically. To achieve this objective through pure SQL or QueryBuilder special problems will not be. But I want to make...
Osvaldo.Dare asked September 23rd 19 at 13:41
2
answers

As when using EAV to add fields to categories?

I want to write a simple e-shop (Yii). Of course, the goods shall be arbitrarily added field, which uses the pattern of Entity-Attribute-Value. How to make so that the field types were assigned to the categories and values - for specific products? That is, for example, the administrator of the site, creating a product, sele...
america_Klein asked September 19th 19 at 13:21