On Fri, 2009-10-23 at 23:53 +0200, Leif B. Kristensen wrote:
> I've followed this list for quite a long time, and I think that I've
> discovered a pattern that I would like to discuss.
>
> It seems like there are two camps considering EAV models. On the one
> hand, there are researchers who thin
On Fri, Oct 23, 2009 at 5:53 PM, Leif B. Kristensen wrote:
> I've followed this list for quite a long time, and I think that I've
> discovered a pattern that I would like to discuss.
>
> It seems like there are two camps considering EAV models. On the one
> hand, there are researchers who think th
Hi Peter,
I agree 100% with you. EAV can be a good "middle of the road" appoach as
you suggest.
Peter Hunsberger wrote:
My take on this, for the research world, is to not go pure EAV, but
rather normalize by some more generic concepts within the domain. Eg.
"measurement", or "evaluation", e
On Fri, Oct 23, 2009 at 5:30 PM, Greg Smith wrote:
>
> Your thinking this is a business/research distinction isn't right, it comes
> down to the size of the data set and how fast/expressive the queries against
> them are. In the research realm, you can watch this struggle play in things
> like bi
On Fri, 23 Oct 2009, Leif B. Kristensen wrote:
I'm a researcher type, and I've made an EAV model that suits me well in
my genealogy research. How can you associate an essentially unknown
number of sundry "events" to a "person" without an EAV model?
CREATE TABLE events(person text,key text,val
On Fri, Oct 23, 2009 at 11:53:26PM +0200, Leif B. Kristensen wrote:
> I'm a researcher type, and I've made an EAV model that suits me well in
> my genealogy research. How can you associate an essentially unknown
> number of sundry "events" to a "person" without an EAV model?
create table person
On Fri, Oct 23, 2009 at 5:04 PM, Tom Lane wrote:
> "Leif B. Kristensen" writes:
>> It seems like there are two camps considering EAV models. On the one
>> hand, there are researchers who think that EAV is a great way to meet
>> their objectives. On the other hand, there are the "business" guys wh
"Leif B. Kristensen" writes:
> It seems like there are two camps considering EAV models. On the one
> hand, there are researchers who think that EAV is a great way to meet
> their objectives. On the other hand, there are the "business" guys who
> thnk that EAV is crap.
Well, no, it's not that
I've followed this list for quite a long time, and I think that I've
discovered a pattern that I would like to discuss.
It seems like there are two camps considering EAV models. On the one
hand, there are researchers who think that EAV is a great way to meet
their objectives. On the other hand,
