Erlang, Javeline / Ajax.org, Life as a hoster, MySQL, PHP, Replies
An alternative way of EAV modelling
I was reading this month’s php|architect. It has a nice article about EAV modeling. I had seen this db structure in other project, but didn’t know that it was called EAV. For those who don’t read php|architect, EAV describes a method of saving a large set of attributes, only some of which apply to an individual entity. Normally you would create a table, with a row for each entity and save each attribute in a column. With EAV you save each attribute as a row.
This makes selecting the data quite tedious. If you can life with some constraints, there is an easier way to do this.
Continue Reading »
29 Jul 2008 Arnold Daniels 26 comments




