2 ms·
> I think I've never used them as column type, but I can imagine a few uses there too. A lot of cases where you would use a one:many are useful to store in an
by snuxoll 11y ago
> I think I've never used them as column type, but I can imagine a few uses there too.
A lot of cases where you would use a one:many are useful to store in an array instead. Tags would be a good example, multi-select lists, etc.
- marcosdumay 11y agoExcept that if you'll want to search by those tags, using an array, instead of a one:many means you'll need a bigger and more expensive index. It's good for some kind of list that you won't search by. That's very limiting, but not an empty set.