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

Ahhh the entity-attribute-value pattern.

When your sql database needs another sql engine to translate to actual EAV queries.

But they are fun schemas!

The old joke that there are two actually hard problems in CS: caching and naming things. The older I get, naming things IMO is far more difficult.



When you start looking at SQL tables that are just id,key,val then you know you've teleported into this forbidden realm.

There are 2 hard problems in computer science: caching, naming things, and off-by-one errors.


It’s even better when you find out that key is a text field, and stores ints, uuids, custom key formats…


And there are a different 'value' column for every possibly data type.


The thing about naming is that it is so closely related to how the problem domain (not business domain, though they are of course related) is understood, and how well it is conceptualized.




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

Search: