News for hackers. Stuff that matters.
Re:Eva – A distributed entity-attribute-value database in Cl... by pmiller2 on Friday June 28, 2019 @11:26AM (#20305260)
EAV is not for everyone. You have to have a data set for which each entity can have values defined for some of, but not all of a large set of attributes. It’s a bit like sparse matrices, actually.

And, yes, you want your tools and application to abstract away some of the messiness involved in something as simple as “load/save this object from the database,” otherwise you’ll end up with a much larger amount of code for such a simple operation. I’ve seen it done in a Django app, and it’s not bad to work with once those abstractions are in place.

Re:Eva – A distributed entity-attribute-value database in Cl... by chrisan on Friday June 28, 2019 @11:41AM (#20305462)
Why not just use a json store for those sparse attributes?

EAV performance at large scale is really dreadful. So many queries.

Re:Eva – A distributed entity-attribute-value database in Cl... by sooheon on Saturday June 29, 2019 @03:30AM (#20311296)
EAV with a query engine and syntax not designed for it is awful. EAV (and AEV and AVE and VAE) with datalog queries is performant, a joy to use, and way more flexible than json stores.