Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

This well-trodden pattern is called EAV (entity, attribute, value). It's attractive up to the point where you want to do interesting things with multiple attributes, which is when you start doing multiple nested self joins on the EAV table and performance gets hairy.

For smaller scale auxiliary data it's fine, but so is JSONB.



Where can I read more about this?





Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: