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.
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.