31 ms·

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 ol

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.

cdchn 3y ago
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.
- sgarland 3y ago
  It’s even better when you find out that key is a text field, and stores ints, uuids, custom key formats…
  - cdchn 3y ago
    And there are a different 'value' column for every possibly data type.
yxhuvud 3y ago
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.