10 events
when toggle format what by license comment
Feb 27, 2015 at 22:29 vote accept CommunityBot
Jan 31, 2015 at 17:46 answer added LR1234567 timeline score: 0
Jan 31, 2015 at 13:38 comment added Joel Brown I've discussed using EAV for product catalogs on Stack Overflow here: stackoverflow.com/questions/11779252/… - EAV is evil, except when it is actually the best approach. Attributes of products in a catalog is one where EAV is often the most efficient and suitable design.
Jan 31, 2015 at 11:56 comment added Walter Mitty The trouble with EAV is that it's difficult to use the data in standard reports, extracts, and other typically useful outputs. EAV is great for capturing data whose structure is yet to be defined.
Jan 31, 2015 at 8:43 comment added a_horse_with_no_name Check out the hstore data type in Postgres. It's a fast and efficient key/value store: postgresql.org/docs/current/static/hstore.html
Jan 31, 2015 at 6:54 answer added Walter Mitty timeline score: 0
Jan 31, 2015 at 1:50 comment added Aaron Bertrand I've blogged about my experiences with EAV: sqlblog.com/blogs/aaron_bertrand/archive/2009/11/19/… That article is SQL Server specific, but the core concepts are the same on any platform. Be careful not to discard a design based solely on articles by people with bias against that design. You need to weigh the pros and cons of all approaches, not just the cons of one.
Jan 31, 2015 at 1:48 comment added Aaron Bertrand I think most of the fears of EAV are just fear-mongering. I've used it quite extensively and I found it to work better than managing sub-types etc. through a variety of specific tables. Some of the cleanliness that you claim goes the other way, too, for example in your preferred approach, if you need to add a new product type you need to add a new table and new access methods, if the same attribute gets added to multiple products (but not all) you have to make the same tedious change to all of those tables and access methods.
Jan 31, 2015 at 1:28 review First posts
Jan 31, 2015 at 4:27
Jan 31, 2015 at 1:25 history asked user35632 CC BY-SA 3.0